| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheet1 from different workbooks contained in a folder to myone and only destination workbook.
Hi All,
Good day everyone. Can anyone help me? I have one workbook with filename "Listing Excel Files in a Folder". I was trying to create a macro in this workbook, which can open all the excel files in a particular folder. Then copy the sheet with sheet name "Pricebook Pages" from these excel files and paste it to the different blank worksheets that i prepared in my workbook "Listing Excel Files in a Folder". The excel files in a folder are pricebooks of different customer. The pricebook data is always in sheet1("Pricebook Pages"). Cheers. Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unprotect 1st sheet in every workbook in a folder and change month inS1 & year in T1 & rename all workbooks | Excel Programming | |||
| Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
| Change Hyperlink Destination Folder | Excel Discussion (Misc queries) | |||
| Copying Several Workbooks into one Workbook as Worksheets | New Users to Excel | |||
| copy sheet1 from all open workbooks to one workbook | Excel Programming | |||
![Jeff[_56_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
