| 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? |
| 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 | |||
Threaded Mode
