Posted to microsoft.public.excel.programming

GregR

external usenet poster

Posts: 246

Compare same Column in 2 Workbooks

I have 2 workbooks and want to compare Column A in both books. If there
is no match for an item in WB1 Column A to WB2 Column A, I want to
highlight or insert a cheater column in WB1 indicating "not in WB2".
Similarly, if something is found in WB2 and not in WB1, highlight in a
different color or "not in WB1". TIA

Greg

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 and Merge Workbooks	PA	New Users to Excel	2	November 6th 09 08:48 PM
Compare workbooks	Andy	Excel Discussion (Misc queries)	11	April 5th 09 11:46 PM
Compare workbooks	Scafidel	Excel Discussion (Misc queries)	2	May 28th 07 09:15 PM
compare different workbooks	kjstec	Excel Worksheet Functions	1	October 17th 06 06:34 PM
compare data from one column with another and compare result to yet another	Matt Williamson[_3_]	Excel Programming	1	September 25th 03 08:54 PM

All times are GMT +1. The time now is 02:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us