General discussion
November 16, 2005 at 09:01 PM
jh46

Sheet Reference (Variable) in Formula

by jh46 . Updated 20 years, 10 months ago

I have a spreadsheet that has each month on a tab. The current month beginning balance is the previous month ending balance. Rather than having to type the sheet name into each beginning balance formula, I would like to type the sheet name into one cell on the spreadsheet and all of the formulas refer to the single cell for the sheet name. Something like =”C2″!F21 and =”c2″!F22 etc where C2 has the name of the previous months sheet name (JAN).

This discussion is locked

All Comments