Thread: copying sheet1 from different workbooks contained in a folder to myone and only destination workbook.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff[_56_] Jeff[_56_] is offline
external usenet poster
  
Posts: 3
Default 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
Reply With QuoteReply With Quote