I'm really looking for some help. I have been successful in a macro when the columns match up. Example, I was able to compare columns A, B, & C worksheet 1 with columns A, B, & C in worksheet 2 and report any exceptions on Workeet 3. I'm having difficulties when the Column I'm trying to compare do not match up in the 2 worksheets.
I have two worksheets. "Inventory" & "Streetscape".
CUSIP column: on the "Inventory" worksheet its located in Column N, on the "Streetscape" worksheet it's located in Column G. This is basically my item name, or item number. it's the MAIN part of my information. all other columns in a line described that CUSIP.
What I would like a Macro to do. When the columns Qty, Acct #, and/or Type of a particular CUSIP DO NOT match in both Worksheets I would like that to be reported in a 3rd worksheet "Exception Report"
"Inventory" worksheet the QTY is located in column B, in Streetscape worksheet the QTY is located in column J.
"Inventory" worksheet the Acct # is located in column S, in Streetscape worksheet the Acct # is located in column A.
"Inventory" worksheet the Type is located in column T, in Streetscape worksheet the Type is located in column U.
I've attached a file of an example with comments on how I would like the MACRO to work. The highlighted columns are the only columns I am worried about.
Some help would really be appreciated!
Bookmarks