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,
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,