Hi.
I have a sheet where I am working out product sales.
In Sheet1 Column A I have all my SKUs.
Each week when I product a report I want to store the current sales into Sheet2 so I can look back over time.
The problem is, as we add new products, the list of SKUs in Sheet1 will grow.
So I need to run through the SKUs on Sheet1 and if I found a matching SKU on Sheet2 then I will simply add the sales for that SKU.
If I do not find that SKU on Sheet2 then I need to add that SKU to the end of the list.
In short I need to compare two lists, then anything in list A that is not in list B, add it to list B, the rest of the copying data I can manage.
I cannot rearrange list B though since it has sales data in other columns. I can only ADD to list B.
I need to do this with a macro as I need to pass off this sheet to a colleague who does not understand Excel too much.
Thanks
I have a sheet where I am working out product sales.
In Sheet1 Column A I have all my SKUs.
Each week when I product a report I want to store the current sales into Sheet2 so I can look back over time.
The problem is, as we add new products, the list of SKUs in Sheet1 will grow.
So I need to run through the SKUs on Sheet1 and if I found a matching SKU on Sheet2 then I will simply add the sales for that SKU.
If I do not find that SKU on Sheet2 then I need to add that SKU to the end of the list.
In short I need to compare two lists, then anything in list A that is not in list B, add it to list B, the rest of the copying data I can manage.
I cannot rearrange list B though since it has sales data in other columns. I can only ADD to list B.
I need to do this with a macro as I need to pass off this sheet to a colleague who does not understand Excel too much.
Thanks