I have a spreadsheet with account numbers in Col A & C. I would like a macro that will extract all numbers that are in Col A C to Col E for eg if 7802 appears in Col A, but But not in Col C, it must be extracted to Col E as it is unique. I also need the heading from each column where the number is being extracted from
I have extracted the unique numbers manually to show what the extraction must look like.
Your assistance is most appreciated
http://windowssecrets.com/forums/showthread.php/147057-Macro-to-compare-number
I have extracted the unique numbers manually to show what the extraction must look like.
Your assistance is most appreciated
http://windowssecrets.com/forums/showthread.php/147057-Macro-to-compare-number
Comparing Account Numbers.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | InputTaxAccountNumbers | COSAccountNumber | AccountNumbersNotMatched | Type | ||||
2 | 7001 | 7001 | 7809 | COSAccountNumber | ||||
3 | 7802 | 7809 | 7802 | InputTaxAccountNumbers | ||||
4 | 7903 | 7903 | 7401 | InputTaxAccountNumbers | ||||
5 | 7325 | 7325 | 7400 | COSAccountNumber | ||||
6 | 7401 | 7400 | 7503 | InputTaxAccountNumbers | ||||
7 | 7503 | 7500 | 7500 | COSAccountNumber | ||||
8 | 7602 | 7602 | InputTaxAccountNumbers | |||||
9 | 7594 | 7594 | InputTaxAccountNumbers | |||||
10 | ||||||||
Sheet1 |