I am trying to create a workbook that creates a copy of a existing worksheet
(for the template), then I paste in information that the arragement never
chages. From the information I pasted in I want it to populate a separate
sheet with the values I selected. The problem I have is is there a way to
auto increment a sheet name within a formula.

The new sheets I copy and create will have the names, Report 1, Report 2,
Report 3 and so on. Is there a way I can make a formula so I can auto fill,
i.e. cell A1 is from Report 1 and cell A2 is from Report 2.

Right now my formula looks like ='Report 1'!A$89

I have also been experimenting with =VLOOKUP('Report 5'!$A$89,'Report
5'!A$89:O$89,1)

Thanks

Trizzle

=INDIRECT("Report" & (ROW()) & "!A89")

Entered in A1


Gord Dibben MS Excel MVP


On Wed, 6 Dec 2006 12:10:01 -0800, Trizzle
wrote:

I am trying to create a workbook that creates a copy of a existing worksheet
(for the template), then I paste in information that the arragement never
chages. From the information I pasted in I want it to populate a separate
sheet with the values I selected. The problem I have is is there a way to
auto increment a sheet name within a formula.

The new sheets I copy and create will have the names, Report 1, Report 2,
Report 3 and so on. Is there a way I can make a formula so I can auto fill,
i.e. cell A1 is from Report 1 and cell A2 is from Report 2.

Right now my formula looks like ='Report 1'!A$89

I have also been experimenting with =VLOOKUP('Report 5'!$A$89,'Report
5'!A$89:O$89,1)

Thanks