macro to import file into specified sheet

[The Transporter]

Hello,

I'm new to VB code and am hoping someone may be able to help me out.

Is it possible to have a macro that will (a) first prompt the user to select an excel file to import (the excel files to import are provided each month and data is always in "Sheet1"); then (b) select which worksheet to import the data (values only) from the selected file into?

I'd really appreciate any help with this...<!-- / message --><!-- attachments -->

 

[ColinKJ]

Hi,

It is possible, but can you paste an example from the workbook where the data is to be imported into,

And an example of one of the data Workbooks where the data is to be copied from.

Regards

ColinKJ

 

[The Transporter]

Hi ColinKJ, thanks for following this up...

By example do you mean an attachment of the actual workbook?

Basically, the workbook where the data has to be imported into has 12 empty worksheets (each named by month -e.g. "Jul","Aug","Sep" etc).
There is then another seperate sheet (named "Summary") that summarises the data across the 12 sheets (e.g. via lookups, sums etc)

The workbooks where the values are to be imported/copied from each month include data in one worksheet ("Sheet1") from columns "A" through to "AZ" (# of rows vary from month to month). Each month this sheet is made available, I basically need to have the macro copy all its values into one of the 12 empty worksheets of the main workbook (e.g. for values in workbook provided for June data to be copied into the sheet named "Jun" of the main workbook)

Thanks again, really appreciate your help...

 

[ColinKJ]

Hi,

Understand what you want, I'll put something together and get back to you.

One thing, with the WBs you are copying from, what row dose the data start at 1 or 2.

Also, with the WB / Sheet that you are copying to, again do you want it to start on row 1 or 2.

ColinKJ

 

[The Transporter]

Hi Colin,

Thanks again for this - the data in the WB to copy values from begin at row 1 - If you could have them copy to row 1 of the main WB that would be great...

 

[ColinKJ]

Hi,

I put together somehing for you to look at, if you can send me a private message with an email address, I'll send it over.

ColinKJ

 

[The Transporter]

Thanks for emailing that across to me, I've tried it out and it definitely meets all requirements...

I really appreciate your time and efforts...