Hi everyone,
I am trying to code a macro that would allow me to compare infomation in two separate worksheets and create a third worksheet with the exceptions listed. A few things to note:
1) The information to be compared will be displayed in the form of data tapes with a set number of columns in Sheet1. This will be compared to a data tape in Sheet2 also with the same number of columns and identical headers, but with a variable number of rows of data.
2) The rows within the datatapes will be identified based on unique ID numbers in both sheets. Thus for example, ID 1 can be in Sheet 1, row 5, which will have to be compared to ID 1, which can be in row 11 (or any other ones) in Sheet2.
3) All differences with be reported in a exceptions report in a Sheet3 of the same file.
4) In terms of formatting, I will need to design an initial user form that will give me the option of choosing whether the numbers being compared are based on the actual number in the cell, or the number displayed.
I am quite the newbie in VBA but have had minor experience. Looked at various other similar codes but can't find what I am exactly seeking. Any pointers would be most helpful.
Thank you in advance.
-NC
Bookmarks