VBA Dictionary - Help

[VBA66]

Hello everyone,
I have an VBA task I would like to completed and am unsure how to do it. It is a finance related question.

In the same workbook I have two sheets, Sheet1 and Sheet2.
In sheet1 I have a table of hundreds of names with a separate table below and in sheet2 I only have an updated table of the same hundreds of names but with maybe 1/2 new ones.
How can I create a macro that will update the table in sheet one based on sheet2. So import the corresponding data into the table in sheet1 and insert any new lines (in the same position as found in sheet two) and remove any that don’t appear anymore in sheet2

many Thanks,

 

[kennypete]

If you remove the ones that are no longer in sheet 2 from sheet 1 and add the new ones in sheet 2 into sheet 1 then the answer will be sheet 2?

I think you need to provide an example of 10 or so names in a exemplar sheet 1 and similarly for sheet 2 and show what you expect as output (modified sheet 1) and why.