filling series problem

[Hot-Rod]

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

 

[RagDyer]

Just how exactly, are you trying to accomplish this?

There'e no problem with using the "fill handle" to drag down and copy and
increment the *cell adress* with either of these formulas:

=Sheet1!A1

=(Sheet1!A1)


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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

 

[David McRitchie]

With or without the parentheses it fills down with the fill handle for
me exactly as you say you wanted in Excel 2000. I expect you are
doing something different than what you say, but I don't know what.

Same for select the area and use Ctrl+D for fill down.

 

[Guest]

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

Sheet1 A1
Sheet2 A1
Sheet3 A1

but I get:

 

[David McRitchie]

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".

 

[Alan Beban]

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