poptart141
New Member
- Joined
- Apr 1, 2013
- Messages
- 4
Hello everyone. I posted this question on another Excel forum last week and no one has responded. 
So here goes nothing...
Here at work as a Project Manager, I have been working on redesigning a spreadsheet that tracks the corporation's current projects individually, and displays each project's most important information into one Summary Sheet. So, the workbook has one Summary sheet, the template for each of the Project Sheets, and then the Project Sheets themselves. I want the Summary Sheet to display the information from Row 3 of each Project Sheet (specifically cells A3:K3) and display that information in a new row for each Project Sheet (so, cells Ax:Kx, with x being the proper row number in the Summary Sheet) automatically with the creation of a new sheet.
The way I've been doing it until now has worked, but my boss wants it to be more automated. I had recorded a macro for Ctrl+Shift+C that would copy A3:K3 of the current Project Sheet you were on, then you would navigate to the Summary Sheet and select the row you wanted that information to go into. Then, I had another macro recorded for Ctrl+Shift+P that would automatically do a paste-link for the correct cells in that row.
I'd like it to be automated so that anytime you insert a new Project Sheet, the workbook automatically links the next row in the Summary Sheet to Row 3 in that new Project Sheet. So, if you have only one project linked that displays in row 3 of the Summary Sheet, when you insert a new Project Sheet, the Summary Sheet will automatically link row 3 from the Project Sheet into the next open row (in this case, row 4). I can't figure out how to make this increment properly with each new inserted sheet. I've tried researching but can't find anything. Any help would be greatly appreciated!
So here goes nothing...Here at work as a Project Manager, I have been working on redesigning a spreadsheet that tracks the corporation's current projects individually, and displays each project's most important information into one Summary Sheet. So, the workbook has one Summary sheet, the template for each of the Project Sheets, and then the Project Sheets themselves. I want the Summary Sheet to display the information from Row 3 of each Project Sheet (specifically cells A3:K3) and display that information in a new row for each Project Sheet (so, cells Ax:Kx, with x being the proper row number in the Summary Sheet) automatically with the creation of a new sheet.
The way I've been doing it until now has worked, but my boss wants it to be more automated. I had recorded a macro for Ctrl+Shift+C that would copy A3:K3 of the current Project Sheet you were on, then you would navigate to the Summary Sheet and select the row you wanted that information to go into. Then, I had another macro recorded for Ctrl+Shift+P that would automatically do a paste-link for the correct cells in that row.
I'd like it to be automated so that anytime you insert a new Project Sheet, the workbook automatically links the next row in the Summary Sheet to Row 3 in that new Project Sheet. So, if you have only one project linked that displays in row 3 of the Summary Sheet, when you insert a new Project Sheet, the Summary Sheet will automatically link row 3 from the Project Sheet into the next open row (in this case, row 4). I can't figure out how to make this increment properly with each new inserted sheet. I've tried researching but can't find anything. Any help would be greatly appreciated!
