Hi everybody,
I'm trying to compile a personal monthly expenses spreadsheet, with a master sheet drawing from monthly sheets. I'm referencing several cells in the master sheet from January, 2007. For exampel, my monthly set costs from January would be referenced from the '01-2007' sheet to the master sheet via:
=('01-2007'!$K$16)
However, I'd like to reference any month without having to manually edit every single '01-2007' to something else, since I have about 20 of these. Would I be able to replace the '01-2007' with say... a variable, dependent on another cell, which I may input? So that I may use somehting like:
=(R1!$K$16)
Assuming I type the name of the sheet (e.g., 02-2007) into R1. Of course, that doesn't work, because Excel simply looks for a sheet named 'R1', which doesn't exist. I'm sure there's an easy solution to this, but I'm just too ignorant to figure it out. Can anybody help??
I'm trying to compile a personal monthly expenses spreadsheet, with a master sheet drawing from monthly sheets. I'm referencing several cells in the master sheet from January, 2007. For exampel, my monthly set costs from January would be referenced from the '01-2007' sheet to the master sheet via:
=('01-2007'!$K$16)
However, I'd like to reference any month without having to manually edit every single '01-2007' to something else, since I have about 20 of these. Would I be able to replace the '01-2007' with say... a variable, dependent on another cell, which I may input? So that I may use somehting like:
=(R1!$K$16)
Assuming I type the name of the sheet (e.g., 02-2007) into R1. Of course, that doesn't work, because Excel simply looks for a sheet named 'R1', which doesn't exist. I'm sure there's an easy solution to this, but I'm just too ignorant to figure it out. Can anybody help??
