| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transferring data from multiple worksheets to a Summary sheet
I want to copy data from the same cell in multiple worksheets and I also want
the ability to update. To speed up the process of creating the Summary sheet, I want to drag down a column in the Summary sheet and change the worksheet # but not change the cell reference , e.g. =('5'!$A$2) allows me to drag and the cell reference will not change but neither does the worksheet. Is there something I can attach to the '5' that allows it to change by one as I drag down? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transferring data from multiple worksheets to a Summary sheet
=INDIRECT(ROW(A1)&"!$B$6")
Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 12:11:02 -0700, Bette wrote: I want to copy data from the same cell in multiple worksheets and I also want the ability to update. To speed up the process of creating the Summary sheet, I want to drag down a column in the Summary sheet and change the worksheet # but not change the cell reference , e.g. =('5'!$A$2) allows me to drag and the cell reference will not change but neither does the worksheet. Is there something I can attach to the '5' that allows it to change by one as I drag down? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transferring data from multiple worksheets to a Summary sheet
Thank you, thank you, thank you. Just what I wanted.
"Gord Dibben" wrote: =INDIRECT(ROW(A1)&"!$B$6") Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 12:11:02 -0700, Bette wrote: I want to copy data from the same cell in multiple worksheets and I also want the ability to update. To speed up the process of creating the Summary sheet, I want to drag down a column in the Summary sheet and change the worksheet # but not change the cell reference , e.g. =('5'!$A$2) allows me to drag and the cell reference will not change but neither does the worksheet. Is there something I can attach to the '5' that allows it to change by one as I drag down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transferring data from multiple worksheets | Excel Worksheet Functions | |||
| Summary sheet for multiple worksheets | Excel Discussion (Misc queries) | |||
| Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
| Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I display data from multiple worksheets in a summary sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
