If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 . |
#2
|
|||
|
|||
filling series problem
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) |
#3
|
|||
|
|||
filling series problem
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 . |
Thread Tools | |
Display Modes | |
|
|