Susan Harkins
ssharkins at gmail.com
Sun Dec 21 11:41:26 CST 2014
Does anyone know of a formula that can reference the previous sheet, regardless of the sheet's name? I've found several uses of Indirect(), but they rely on the sheet names being labels somewhere else and that actually complicates things. In this case, I have a fixed number of sheets -- January through December. It's just as easy to reference each sheet by name as it is to create a table of names somewhere. What would be beneficial and simpler is a single formula that can reference the same cell in the previous sheet, regardless of the sheet it's in. February: 'January'!B2 March: 'February'!B2 April: 'March'!B2 and so on... If I could use the same formula in each sheet, it would be simpler. Susan H.