babypink2807
New Member
- Joined
- Jul 13, 2015
- Messages
- 41
- Office Version
- 2016
Good afternoon
Hope someone can help. I have two workbooks that lists the following, one list is last week and one list is this week. I need to find out from this weeks new list, which rows are not on the previous weeks list. I have on an average 3000 rows each week. I would like the new sheet to identify those rows that are NOT on the previous weeks list if its possible. I have watched various youtube videos but cannot seem to find the answer to it. I did conditional formatting by merging them but I ended up having to delete each individual row that was a duplicate. I need to see the NEW rows because I have to then add them to another database.
Serial Number 123456
Date Of Sale 12/07/2021
Machine Model KW 6.0/8
The above data if it matches in the previous sheet workbook great. If the above machine is not on the previous weeks list then I need Excel to indicate this is NOT on the list
Many thanks in advance
Hope someone can help. I have two workbooks that lists the following, one list is last week and one list is this week. I need to find out from this weeks new list, which rows are not on the previous weeks list. I have on an average 3000 rows each week. I would like the new sheet to identify those rows that are NOT on the previous weeks list if its possible. I have watched various youtube videos but cannot seem to find the answer to it. I did conditional formatting by merging them but I ended up having to delete each individual row that was a duplicate. I need to see the NEW rows because I have to then add them to another database.
Serial Number 123456
Date Of Sale 12/07/2021
Machine Model KW 6.0/8
The above data if it matches in the previous sheet workbook great. If the above machine is not on the previous weeks list then I need Excel to indicate this is NOT on the list
Many thanks in advance