Compare columns edit VBA code

I copied this macro from the Microsoft website. It compares two columns of data for matches in both and then returns the matches in Column "B". What I'd like it to do is prompt for the first column, say "G" and the second column, say "I". I'd also like it to prompt what column the matches should be put in. It defaults to putting the matches in Column B but if I have data in Column A and B that must be near each other it makes it so I can't use this macro. Please ask for clarification if needed! Thanks.

Please Login or Register  to view this content.