I am not sure I understand the whole project. I think I understand this part
I want to Pre Create, and Pre Name worksheets, and Add Dyanamic Formulas to them to reference a list of projects.
In order to use a grouped sheets approach do these preliminary steps:
Standardize the 'Project #' sheets so they have the same format.- All rows and columns are in the same locations relative to each other.
- Headers in 'Project #' sheets are identical to 'Project Entry' headers.
- Group Project sheets. If you are not familiar with how to do this click 'Project 1' and while pressing the Shift key click 'Project 4'
- This will enable all formulas entered in 'Project 1' to populate the other Project sheets with appropriate relevant references.
- In A1 enter this formula
- It will return each Project sheet's name in it's cell A1.
- I encourage doing this once in A1 rather than down column A of each grouped sheet. The reason is that the CELL function is volatile. It and all its dependents must recalculate with every edit whether relevant or not. Doing this in A1 you can copy A1 (still grouped) and paste back to A1 values only. It is no longer volatile.
Then with sheets still grouped enter this in a7 as in the attached and fill down.
Then in B7 filled down and across
Bookmarks