Append Data to Original Dataset Using Macro

[sabo10]

Hi All,

I was wondering whether anybody could help with the following task I am faced with. I am a VBA beginner and I am having trouble appending some data to an original dataset.

I am trying to search a reference in a one spreadsheet and append the relevant fields to the end of the dataset. The number of fields to be appended to the original dataset can vary. I have attached an example for your reference.

Any help would be greatly appreciated.

Thanks