Hi all
I am currently building 12 monthly reporting spreadsheets and each one had a worksheet for each day of the month. I have a formula which locates information from the previous sheet on each sheet:
=vlookup(B6,'2nd'!$B$6:$E$21,3,0)
What i want to be able to do is set this up so that one formula works on every sheet in that month, just selecting the previous tab's data. at the moment i have to go in and change the tab name on each worksheet, so on the 3rd it references the 2nd, on the 4th it references the 3rd, etc etc.
Can anyone help with this?
B.
Bookmarks