Hello,
I have posted my sample workbook.
I have a workbook used to track inventory. I'd like to automate the process of comparing the substates from two sources and output the serial numbers which have different substates to a third sheet. I believe it would require the following steps:
1. Take the serial number column (which is column A) from the sheet "Hardware(Serial Number)", find its matching value in the serial number column (which is column A) from the sheet "Service Now".
2. Compare the substate column those two rows (columns G and F from their respective sheets)
3. For any serial number entry where the two substate columns do not match, print the serial number and two substate fields to columns E, F, and G of the "AFTER" sheet.
4. Repeat until the end of the table is reached.
Would someone be willing to put that into VBA?
Bookmarks