I am looking for an Excel macro or utility which can automate the following procedure which I commonly use. Here is the scenario:
I have data in Sheet 1 and in Sheet 2. I need to compare data in a specific column of Sheet 1 against data in a column in Sheet 2. I need to find data which is in Sheet 1 but not in Sheet 2; and data in Sheet 2 not in Sheet 1.
I would like the macro to:
1) prompt which column in Sheet 1 and which column in Sheet 2 I want to compare. This allows me to enter: A or B or whatever
2) list out on Sheet 3 data in Sheet 1 not on Sheet 2
3) list out on Sheet 4 data in Sheet 2 not on Sheet 1
Please note that the two columns I may be comparing can be all numeric, or all alpha, or all alpha-numeric; but no mixtures of different data types.
I am attaching an example file.