Rip1971
Board Regular
- Joined
- Nov 3, 2020
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
Hi all,
i am looking for code that combines multiple action into one.
i am using 2 workbooks reports january2020 and december2020 (but can be any month) and want to compare between the 2 workbooks what ItemsID have been removed since january till now (december) and export the removed ItemIDs to a new sheet. i would also like to count how many times this ItemId has been removed since previous report. something like tabel below
All my reports have the same layout and i would like to compare column F.
if more information is needed please let me know.
thanks in advance for all the help i get.
i am looking for code that combines multiple action into one.
i am using 2 workbooks reports january2020 and december2020 (but can be any month) and want to compare between the 2 workbooks what ItemsID have been removed since january till now (december) and export the removed ItemIDs to a new sheet. i would also like to count how many times this ItemId has been removed since previous report. something like tabel below
| January | December | Export (new sheet) |
| A | A | B removed 2 times |
| B | C | |
| C | D | |
| B | D |
All my reports have the same layout and i would like to compare column F.
| USR02-Dow Training Compliance 02_18.csv | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 2 | User ID | First Name | Last Name | Days Remaining | Required Date | Item Id | Item Title | Curriculum Id | Curriculum Title | ||
Data | |||||||||||
if more information is needed please let me know.
thanks in advance for all the help i get.
