Can anyone help?
I have data in several source workbooks which is linked to another single summarising destination workbook. When I change the value in a cell in the source workbook from a projected value to an actual value I am currently identifying this by changing the fill colour, i.e.from projected value = blue to actual value = no fill, and then have to do the same in the summarising workbook, but with literally thousands of entries this is becoming time consuming.
Is there any way that when I format the cells in the source workbook that this change also happens in the destination workbook, I have tried if statements and conditional formatting but keep coming up short.
I have data in several source workbooks which is linked to another single summarising destination workbook. When I change the value in a cell in the source workbook from a projected value to an actual value I am currently identifying this by changing the fill colour, i.e.from projected value = blue to actual value = no fill, and then have to do the same in the summarising workbook, but with literally thousands of entries this is becoming time consuming.
Is there any way that when I format the cells in the source workbook that this change also happens in the destination workbook, I have tried if statements and conditional formatting but keep coming up short.