Macro to match cells and import data from source file

Hi Folks,

I have two workbooks. One is a template the second is source data. Not everything in the template will necessarily be in the source data (the tab in both source and template is called "Generated Question Set")

What I'd like to do is match the value in column B and if it exists within column B of the source data, import the values in column D and E from source to template.

This is the template:
Template.jpg

This is the source data:
Source Data.jpg

As you can see, items 5.1, 5.2 and 6.1 are not included in the source data. Therefore, only the values in 5.3, 5.4 and 5.5 would be copied from source to template.

I'd also like it so when the macro (let's call it "importdata ()") is activated, it opens an explorer window so the user can select the source data file.

Anyone got any bright ideas on how I might achieve this?

Many thanks

Terry

Open your destination workbook that contains the template and place this macro in a regular module and run the macro from there.

Please Login or Register  to view this content.

Save the workbook as a macro-enabled file.

Hey Mumps,

That looks good but I'm encountering a problems inasmuch as it won't import the data. Could that be because the values in column B in the 'destination' workbook are generated by formula rather than as direct inputs?

The File called 3rd Party Supplier Assessment - Stripped Template (supplier name) is the destination workbook
The File called 3rd Party Supplier Assessment - Stripped Test Company is the source workbook with some dummy data inserted.

You can ignore many of the tabs as they're used to feed the generated queston set dependent upon the answers given in the Preliminary Question Set tab.

I didn't realize that you had formulas in columns A and B. Assuming that the data in column B will always be numeric, try:

Please Login or Register  to view this content.

Wow! Now that was quite a compliment!! Thank you for the rep and it was my pleasure to help.