I'm currently working a sheet which relies on different sets of exported pdf to excel graphs which are all similar however sometimes out by 10 or so rows. I have the formulas set out so when it all works its perfect however sometimes its not and I need to select 5-6 columns in a row and shift the data down. When I do this the formulas change to follow where it would have been originally despite setting the formulas as absolute
In the attached file for example I want to shift cells down of columns of A to J from the row 610 to be even with the #1 on row 632 however the formula needs to stay the same. Help please
Bookmarks