Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Comparing lists nad printing new/ old in a list box

Hi Im really lost and need some help - havent used VB in a few years an
need a refresher...heres what Im trying to do. I know its simple, jus
cant get the

I have two lists, old and new. I used the conditional formatting i
Excel to highlight and bold those in Old that do not appear in New, an
those in New that do not appear in old.

Now, I have two listboxes, one entitled Old and one entitled New.
want to loop through cells A4:A135 and print those that are bold
because they dont appear in New) in ListOld and similarly, want to loo
thorugh cells B4:B135 and print those that are bold in ListNew.

I know this is probably really simple, any help would be GREATL
appreciated.

Thanks so much!!!!!

By the way, Im using Excel 2000

--
Message posted from http://www.ExcelForum.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Comparing Lists PAL Excel Worksheet Functions 2 August 8th 08 04:40 PM
comparing two list and need to find exact in both lists bill Excel Worksheet Functions 1 September 14th 07 05:58 PM
Comparing two lists ExcelHelpNeeded Excel Worksheet Functions 3 September 5th 07 08:18 PM
Comparing 2 Lists inomata Excel Discussion (Misc queries) 0 July 7th 05 12:45 PM
Comparing two lists Kyle New Users to Excel 5 May 10th 05 11:53 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"