Simple VBA to import data from another excel file

**ShareTheGlobe** · 07-26-2012, 05:37 PM

Hi,

Does anyone by any chance know of a VBA (or maybe help me start out to build one

) that can do the following:

I click on a button and then a selection from one sheet from another excel document is pasted in the current document.

However these are the conditions:
-The user should be able to specify which document should be copied from. So a pop up appears in which the user selects the document to copy from.
-I want to preset the specified sheetname and range that should be copied from and also preset where to copy it to.

For example user selects data.xls and then all information contained in cells from sheet1 A1:Z100 of that document will be copied into sheet2 A1:Z100 of the current document.

I would be very grateful, thanks in advance!

Suzan

**tigeravatar** · 07-26-2012, 06:42 PM

Suzan,

Something like this?

Please Login or Register  to view this content.

**ShareTheGlobe** · 07-26-2012, 07:00 PM

Wow!!! Unbelievably amazing!! You just made my day

thanks a million!!!!

**Cutter** · 07-26-2012, 08:59 PM

@ ShareTheGlobe

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.