| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying multiple cells out of multiple worksheets at same time.
In Excel 2003 I was wondering if it is possible to copy multiple cells A1:O75
in multiple worksheets (sheet1, sheet2, sheet3, etc) and pasting them Consecutively into one work sheet (all records)? Thanks for the help. Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying multiple cells out of multiple worksheets at same time.
One at a time with a one click looping macro
for each ws in sheets.count ds=Sheets("destinationsheetnamehere") if ws.name<ds then lr=ds.cells(rows.count,1).end(xlup).row+1 ws.range("a1:o75").copy ds.cells(lr,1) end if next -- Don Guillett Microsoft MVP Excel SalesAid Software "tom" wrote in message ... In Excel 2003 I was wondering if it is possible to copy multiple cells A1:O75 in multiple worksheets (sheet1, sheet2, sheet3, etc) and pasting them Consecutively into one work sheet (all records)? Thanks for the help. Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Updating multiple graphs in multiple worksheets at the same time | Excel Discussion (Misc queries) | |||
| Copying Cells From Multiple Worksheets to Create Summary Sheet | Excel Discussion (Misc queries) | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
Linear Mode
