Hi,
I have been trying to figure out a solution for comparing 2 Excel sheets. Basically every week I need to generate a report. In that report it will display a list of vulnerable items. Each week I go through the list see what items are existing vs new.If the Row is existing I copy the last 4 columns. If it is new then I have to add information.
So I would like to take out the manual process of cross-referencing to see if the item exists in the previous week's sheet and use a VBA script.
So here are some caveats with the report I am working with
- There was no single column as unique identifier in Sheets1(new report) and 2(old report), so I'll need to create a temporary identifier column with combining Columns A,B, F (ie =A2&B2&F2)
- If it finds a match of the unique identifier column in both sheets, then I want to the data in columns P, Q, R, S copied and pasted to Sheet1(new report) per row.(This should not be simply a reference to sheet1, but an actual copy/paste of the data in the cell)
- Afterwards I want to delete Sheet2(old report)
I am going to try to attach a sample XLS to show as an example if needed.
Thank you,
Jason
Bookmarks