Formulas for Multiple sheets in a workbook

G

Guest

Am creating a wookbook with muliple sheets (50) and want to link info from
sheet 1 to sheet 2 and from sheet 2 to sheet 3, etc. On shhet 2 I am using
the following formula: 'Sheet 1'!A2, 'Sheet 1'!etc. Not all the info needs to
transferred... some rows have daily info to be typed in daily. How do I
create new sheets without having to change the formula in each cell by
changing: 'Sheet 1'!A2 to 'Sheet 2'!A2. Any help would be great. This
workbook is a daily report that has some info that changes daily and some
that does not change.

Thanks, Gary
 
G

Guest

this might be a good place for the indirect() function
have a column with the number of the sheet you want to reference
and in the equation
=indirect("'Sheet " & A1 & "'cell")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary from multiple sheets 1
Merge Multiple workbook sheets into one workbook 0
Complex formula help , please. 13
In Excel how do I update cells in multiple sheets simultaneously? 1
how to serial sheets in workbook 1
create a macro 6
copying data from master ti individual sheets 3
Code to format cells on several worksheets 2

Top