Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Compare two Sheets

I have data in two sheets, say names in column A

I want to compare them and generate a report in sheet 3 seperately
identifying that are not in other sheet.

something like
Column A name
Column B "Not in sheet2:
Column A name
Column B "Not in sheet1

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare 2 sheets	lilo	Excel Programming	1	October 21st 09 11:46 PM
Compare two sheets	CC	Excel Discussion (Misc queries)	0	December 11th 08 03:01 PM
Compare sheets	[email protected]	Excel Programming	1	July 17th 07 08:17 PM
compare two sheets	rexmann	Excel Discussion (Misc queries)	2	February 14th 07 03:07 PM
Compare Sheets	wayliff	Excel Discussion (Misc queries)	0	January 13th 06 08:14 PM

All times are GMT +1. The time now is 02:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us