Is there a way to define a name that can be used as a reference or variable? I have a sheet with my print forms on them. I also have account sheets for each month. I want the print form to take values from a defined month sheet, fill in the fields and then print it. Is there a way top define a constant or variable that can be used in a formula name? This is what I am trying to do.
Cell C9 on the print form imports data from =Jan!C4. I have 50 lines in column C and other columns on the Jan sheet that needs to be imported into the print form. How can I defined a constant or name such that I can use the syntax =PrintMonth!C4, where PrintMonth can be changed to point to the month I want to print. PrintMonth would be used in every column/row as a reference to the correct cell on the month sheets.
I tried to define a name PrintMonth that could be used as a variable but Excel turns that into ='Jan' which cannot be used as a variable in the sheet path to cell Jan!C4.
What am I missing or doesn't Excel have a concept of a variable in a formula path? I have hundreds of cells that I need to reference from the print form sheet. It would be insane to have to create a name for each cell. Or is this a job for a macro or VBA?
Thanks,
Barry
Bookmarks