| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying same cell diff worksheets to new sheet
I have many titled worksheets in one workbook. I want to copy cell a10 and
cell J10 from each worksheet to a new worksheet in the same workbook so column a lists all the cell a10 data and Column B lists all the cell J10 data. Each worksheet has its own name. What's the easiest way to accomplish this? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copying same cell diff worksheets to new sheet
Try this macro that create links to the cells
http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "deb" wrote in message ... I have many titled worksheets in one workbook. I want to copy cell a10 and cell J10 from each worksheet to a new worksheet in the same workbook so column a lists all the cell a10 data and Column B lists all the cell J10 data. Each worksheet has its own name. What's the easiest way to accomplish this? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Cell reference in diff worksheets | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Questions on copying from one sheet to the other and coping every other cell. | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
