| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple sheet cells in one column
I have a multiple-sheet workbook, and on the final sheet, I need to take cell
A1 from each of the earlier sheets and make a column. I know that say cell A1 on my final sheet should be "=,1,!A1", and cell A2 would be "=,2,!A1", etc. I have a pile of sheets where this needs to be done multiple times. Is there any way to automate this? If I just pull down the box, it advances the row number, and I'm wondering if there's a way to do it so it advances the sheet number instead. TIA!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
| Concatenate Column C in multiple sheets into single sheet. | Excel Discussion (Misc queries) | |||
| copying one cell in multiple sheets into a column on one sheet | Excel Worksheet Functions | |||
| Can I print a single column sheet as multiple columns? | Excel Discussion (Misc queries) | |||
| Sum From multiple cells on another sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
