I need help I got this code to import multiple selections from a sheet and paste them in the same location on the new sheet.
Right now when I have my workbook open to an Inventory page I can import an existing inventory sheet that is already complete.

With my existing sheet open
I manually open an older sheet (they are all formatted exactly the same) has a lot of Merged cells that is why i chose this instead of re-merging them after it pastes.
I select the ranges i want to be copied to the new sheet using the Ctrl to select multiple areas.
once that is done I return to sheet i want it on and run macro which asks to select top left Cell. and when you hit enter it pastes all the ranges you have selected to their same spots on the sheet you want it on.


I would like when you run the macro ...1st pop up for you to select the file .....so you can select your ranges.
leave file open and let you select the range then after selecting the ranges be able to proceed with the rest of the macro
then close sheet your opened to copy.

Right now it asks for your file to open and once it does it automatically goes into the
Prompt: Specify the upper left cell for the paste range





Please Login or Register  to view this content.