$$Excel-Macros$$ Merge 2 sets of data

Please find the file Hi all, I have a task that I can achieve up to one point using vlookup but afterwards I need to manually add rows or columns to update the data with a new set of data. It is understood the from the first set nothing should be deleted. Even if one row is empty from the first s

$$Excel-Macros$$ Merge 2 sets of data

Hi all, I have a task that I can achieve up to one point using vlookup but afterwards I need to manually add rows or columns to update the data with a new set of data. It is understood the from the first set nothing should be deleted. Even if one row is empty from the first set is not present