Hi - I need advice from you excel gurus out there. While I know my way
around excel pretty well. I'm no programmer and I need to automate a
file compare routine and am not sure how to go about doing it. Here are
the basics.

I have to spreadsheets and I need to to a cross match.. I've looked at
shareware that produces Difference Reports, but that doesn't quite do
the job.

Both spreadsheets have the same column headers. I need to create a
routine that compares each file... ignores exact matches and returns a
data on a new spreadsheet that shows what is on one spreadsheet and not
the other. Basically to do a cross match and spit out the
irregularities.

I'd love some help with this.. can anyone out there walk me through
what I need to do? Or, is this too challenging a task for Excel and
should I pull out the bug guns (VBA)?

Thanks!

Mizzrizz


--
mizzrizz
------------------------------------------------------------------------
mizzrizz's Profile: http://www.excelforum.com/member.php...o&userid=35515
View this thread: http://www.excelforum.com/showthread...hreadid=552878