Reference to another sheet name in formulas
Posted by David on January 25, 2001 6:20 PM
Hi,
I must to do a spreadsheet with one page for each
day of the month. I'll put in each page many formulas
with references to cells in the previous page.
Is there a way to automatize this job?
In an example: on sheet 3 there will be lots of cells
with formulas like '2'!k22+'2'!n43. I'd like to put
the name "2" on a cell and reference his content, so
I could duplicate the sheet many times and change just
one or two cells to correct the values.
Does anybody knows how can I do it? I found the
INDIRECT function, but I was unable to use it.
Thanks in advance.