Hi All,
I tried a similar question on Friday and worded it badly so hopefully this will explain better today.
I have a two tab spreadsheet and on tab2 I want to complete some calculations.
In cell C1 of "tab2" I want to return the total from column BA of "tab1", the length of BA is from BA4 - BA33726. Problems arise however as I want to drag this formula down to cell C40, however within cell C2 I want the contents from BB and so on, how is this possible?
Thanks
I tried a similar question on Friday and worded it badly so hopefully this will explain better today.
I have a two tab spreadsheet and on tab2 I want to complete some calculations.
In cell C1 of "tab2" I want to return the total from column BA of "tab1", the length of BA is from BA4 - BA33726. Problems arise however as I want to drag this formula down to cell C40, however within cell C2 I want the contents from BB and so on, how is this possible?
Thanks