| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy sheets into one book
Hi
I have number of workbooks in C:\My Documents and I would like to copy sheet1 from all of them and paste it into new book. Is there a macro to do it? -- Greatly appreciated Eva |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy sheets into one book
Check out Ron de Bruin's site:
http://www.rondebruin.nl/tips.htm Specifically, his article on merging multiple workbooks: http://msdn.microsoft.com/en-us/library/cc837974.aspx -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Eva" wrote: Hi I have number of workbooks in C:\My Documents and I would like to copy sheet1 from all of them and paste it into new book. Is there a macro to do it? -- Greatly appreciated Eva |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy sheets into one book
Awsome
Thank you -- Greatly appreciated Eva "Luke M" wrote: Check out Ron de Bruin's site: http://www.rondebruin.nl/tips.htm Specifically, his article on merging multiple workbooks: http://msdn.microsoft.com/en-us/library/cc837974.aspx -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Eva" wrote: Hi I have number of workbooks in C:\My Documents and I would like to copy sheet1 from all of them and paste it into new book. Is there a macro to do it? -- Greatly appreciated Eva |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| work book sheets | Setting up and Configuration of Excel | |||
| copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| How do I reconcile two sheets with in a .xls book? | New Users to Excel | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Linear Mode
