Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-sheet autofill
I have information (numbers) ranging on Sheet1A1 to Sheet1GS1.
I would like to copy these numbers onto Sheet2 ranging from A1 to A150. I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2. When I try to Autofill, I would like the results to show =Sheet1C1 on Sheet2A3 all the way down Sheet2. However, when I try to autofill the program will not keep the pattern I have written above. What can I do to make the autofill follow my pattern? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-sheet autofill
Rich
Non-linked........Copy Sheet1 row 1 and Paste SpecialTranspose to Sheet2 A1 Linked.............In Sheet2 A1 enter this formula. =INDEX(Sheet1!$A$1:$GS$1,ROWS($1:1)) drag/copy down to A150 Note: A1:GS1 is 201 columns so you may want to copy down that far. Gord Dibben Excel MVP On Mon, 19 Dec 2005 13:43:25 -0800, "RichH" wrote: I have information (numbers) ranging on Sheet1A1 to Sheet1GS1. I would like to copy these numbers onto Sheet2 ranging from A1 to A150. I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2. When I try to Autofill, I would like the results to show =Sheet1C1 on Sheet2A3 all the way down Sheet2. However, when I try to autofill the program will not keep the pattern I have written above. What can I do to make the autofill follow my pattern? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-sheet autofill
That worked perfectly! Thank you very much for your quick response!!!
"Gord Dibben" wrote: Rich Non-linked........Copy Sheet1 row 1 and Paste SpecialTranspose to Sheet2 A1 Linked.............In Sheet2 A1 enter this formula. =INDEX(Sheet1!$A$1:$GS$1,ROWS($1:1)) drag/copy down to A150 Note: A1:GS1 is 201 columns so you may want to copy down that far. Gord Dibben Excel MVP On Mon, 19 Dec 2005 13:43:25 -0800, "RichH" wrote: I have information (numbers) ranging on Sheet1A1 to Sheet1GS1. I would like to copy these numbers onto Sheet2 ranging from A1 to A150. I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2. When I try to Autofill, I would like the results to show =Sheet1C1 on Sheet2A3 all the way down Sheet2. However, when I try to autofill the program will not keep the pattern I have written above. What can I do to make the autofill follow my pattern? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
How to get a row consecutive from a sheet to another | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
autofill next sheet with next set of dates | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |