Hello,

I'm looking to create a macro that can do a data merge. (At least, I think that's what it's called? Google seems to differ).

I attached an example. DataMergeExample.xls

1) Tab 1 includes source data. Imagine this could be hundreds of rows and dozens of columns across.
2) Tab 2 is a place to add information that you'd like to update in Tab 1. The "Item Number" acts as a "key" to identify the rows.
3) On Tab 2, the user can go in and, using the Item Key, add the other columns they would like updated. In my example, those particular items are updating vendor name. The column titles will always match between Tab 1 and Tab 2.
4) The macro executes and throws the correct Vendor name over the data entry in Tab 1. All other rows/columns are left alone. The macro would need to be able to execute from multiple columns in Tab 2. (ie, it would do updates until it came to a blank column).

I know this is vlookup, basically, but the data on Tab 1 cannot have forumulas; it has to be all raw data. Hence, there needs to be a way to match.

If you can provide a link to this already described, I can work from that...I just don't know what this is called.

Let me know if you have questions, thank you!
Nick