filling series problem

Sorry, other way around, I want it to fill like:

Sheet1 A1
Sheet2 A1
Sheet3 A1

but I get:

=(Sheet1!A1)
=(Sheet1!A2)
=(Sheet1!A3)

-----Original Message-----
Hi, anyone know how to fill a series that contains a
formula?

I want to fill a column so it fills like this:

=(Sheet1!A1)
=(Sheet1!A2)
=(Sheet1!A3)

Everytime I do it, it wants to add an increment to the
sheet, and not the 2nd half of the formula....

thanks in advance
.

Since you indicated, you stated it backwards and you really wanted

Sheet1 A1
Sheet2 A1
Sheet3 A1

will assume you still wanted formulas generated, if not you can
skip a few steps.

A20: ="=Sheet" & ROW() - 19 & "!A1"

fill down and you have constants
Select the area, Ctrl+C (Copy), Edit, Paste Special, Values

To convert the constants to formulas you can use F2 then Enter
or you can use TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Another page you might want to look at is
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
if you are trying to set up a table with values from specific sheets.
Note I hardly every leave sheetnames for permanent sheets
with names beginning with "Sheet".
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


wrote in message ...
Sorry, other way around, I want it to fill like:

Sheet1 A1
Sheet2 A1
Sheet3 A1

but I get:

=(Sheet1!A1)
=(Sheet1!A2)
=(Sheet1!A3)

The following will fill it like

Sheet1!A1
Sheet2!A1
.. . .

="Sheet"&ROW(A1)&"!A1"

Did you really want a space rather than the exclamation point?

Alan Beban

wrote:

Sorry, other way around, I want it to fill like:

Sheet1 A1
Sheet2 A1
Sheet3 A1

but I get:


=(Sheet1!A1)
=(Sheet1!A2)
=(Sheet1!A3)


-----Original Message-----
Hi, anyone know how to fill a series that contains a
formula?

I want to fill a column so it fills like this:

=(Sheet1!A1)
=(Sheet1!A2)
=(Sheet1!A3)

Everytime I do it, it wants to add an increment to the
sheet, and not the 2nd half of the formula....

thanks in advance
.