Need some help fine tuning this code which will copy an entire worksheet into an open workbook, copy the imported worksheet to a Worksheet named "Posting" and then delete the imported worksheet. I would like to modify the code to open a drop down of all the Excel files in the Folder "C:\MFG_STATISTICS\NYC\NYC_Charts so that I can select the file to be imported and also stop the message "Data may exist in the sheet(s) selected for deletion. To permanently delete the data press delete." after the code. Thanks!!

Please Login or Register  to view this content.
is run.

Please Login or Register  to view this content.