| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same cell in multiple worksheets onto one worksheet
I have the following worksheets: May 1, June 6, July 9.
I want the cell B4 from each of these worksheets to fill in a column on a new worksheet labeled date. Then I need cell G15 from each worksheet filled in under a column labeled results. What would be the best way to go about this??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy same cell in multiple worksheets onto one worksheet
I would list the worksheet names (exactly as they appear on the tabs)
in a column somewhere on the Date sheet. Suppose this is in L4 downwards. Then in A2 (say) you can have this formula: =INDIRECT("'"&L4&"'!B4") and this one in B2: =INDIRECT("'"&L4&"'!G15") Then you can copy these two down for as many sheets as you have in column L. Hope this helps. Pete On Sep 16, 11:02*pm, Tia wrote: I have the following worksheets: *May 1, June 6, July 9. I want *the cell B4 from each of these worksheets to fill in a column on a new worksheet labeled date. *Then I need cell G15 from each worksheet filled in under a column labeled results. *What would be the best way to go about this??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to copy data from one worksheet to multiple worksheets at once | Excel Worksheet Functions | |||
| copy a cell from multiple worksheet | Excel Discussion (Misc queries) | |||
| Copy range from one worksheet and paste to multiple worksheets | Excel Discussion (Misc queries) | |||
| Copy Range From Multiple Worksheets to a Single Worksheet | Excel Discussion (Misc queries) | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
Linear Mode
