How to automatically update an 'Overview' sheet when adding a worksheet to the spreadsheet

martin fuller 0 Reputation points
2024-09-22T02:49:38.3066667+00:00

I have a spreadsheet that contains many worksheets. All worksheets have the same layout. There is an 'Overview' sheet that updates automatically if the data in the worksheet alters.

I can 'add' a new worksheet in the middle of the worksheets. I use a blank worksheet that has the same layout as all the other worksheets waiting for the data to be entered. This is then automatically shown in the overview sheet as an xlsm spreadsheet.

On the overview sheet select the cells before the inserted sheet and click insert -Down. The past-linked data is then moved down so correspond with the correct worksheet.

QUESTION:-

Is there a way adding the new blank worksheet will automatically copy-paste-link the cells to the 'Overview' worksheet? Every time I add a new worksheet I have to copy paste-Link 13 cells!

I seem unable to attach a cut-down copy of the overview, worksheets, and 'Blank' new worksheet used to add a new account. I have added the Overview sheet, a worksheet, and the blank sheet. You will note there is a macro and this allows for the worksheets to be automatically updated when moved around. Once the copy past linked data is set up that can be moved around fine when worksheets are added/deleted. The issue is adding a new blank worksheet and having to add the 13 copy-paste link cells.

Can anyone advise had to have the blank sheet automatically update the overview sheet?

Thanks

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,648 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.