Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data
Hi,
I have 87 sheets in a workbook were all sheets contains some data in different cells. I want to copy that cell data from all sheets to a new sheet or a new workbook so its becomes more easy to process. Anyone who have a good tip? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data
set wkbk = ActiveWorkbook
workbooks.Add set shDest = Activeworkbook.Worksheets(1) for each sh in wkbk.Worksheets sh.Range("A1:B200").Copy Destination:= _ shDest.Cells(rows.count,1).End(xlup)(2) Next -- Regards, Tom Ogilvy "LSN" wrote in message ... Hi, I have 87 sheets in a workbook were all sheets contains some data in different cells. I want to copy that cell data from all sheets to a new sheet or a new workbook so its becomes more easy to process. Anyone who have a good tip? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy none excel data & paste in 2007 without overwriting data | Excel Discussion (Misc queries) | |||
filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions |