Forum Discussion
Repetative references to Sheets
HI All I am setting up a spreadsheet, where i have separate sheets for each Month and a summary sheet, where I want to pull in specific data from each of the month sheets. I want specific ce...
Maybe this is not a world-changing solution but the INDIRECT function may help you.
You can set up an auxiliary range in your summary sheet with the names of all months. Then, use, for instance:
=INDIRECT(B1&"!"&"D2")
Where B1 would be a cell in your summary sheet containing "24 April". In that way, you can keep adding months and then dragging the formulas accordingly so that the only manual action would be to drag the existing formulas...
