UncleBob
11-17-2015, 05:00 AM
Hi there,
I need some help please.
The screenshot below is a file that shows who is working on which procject.
The data in C1 rightwards and A5 down are copied in each month by macro. Rows 2,3&4 are all formulas.
The problem is when a new project is added (say, "508 project") the formulas C5 down & right need changing to the file path & name in row 3 - is there a formula or macro that will do this for me please?
(I can't use INDIRECT as it would require all 70+ files to be open to work).
Thanks in advance
Paul
14781
I need some help please.
The screenshot below is a file that shows who is working on which procject.
The data in C1 rightwards and A5 down are copied in each month by macro. Rows 2,3&4 are all formulas.
The problem is when a new project is added (say, "508 project") the formulas C5 down & right need changing to the file path & name in row 3 - is there a formula or macro that will do this for me please?
(I can't use INDIRECT as it would require all 70+ files to be open to work).
Thanks in advance
Paul
14781