LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default comparing values

column E in sheet A has values, a different one in each row (ranging from 50
to 500 values, depending on workbook we're working in)

column T in sheet B has values, thousands of them
the contents of sheetB are delivered by an external source

values in colT / sheetB should be named in colE / sheetA (theory)
there are values in colT / sheetB that are not present in colE / sheetA
(practice)

these need to be pointed out so after that it can be decided to discard
these lines or add the value to colE / sheetA

I want to run code to check the values of colT/sheetB
if a value in colT/sheetB isn't present in colE / SheetA then it should
print the value in the current (different) sheet

I've tried a few things now ~ I'm taking a wrong turn somewhere
any good ideas out there?
 
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
Help with Comparing values and retrieving values in Excel!!!!!! [email protected] Excel Worksheet Functions 1 November 17th 06 12:21 AM
Comparing values between columns only when there are values in bot Mark K Excel Worksheet Functions 1 February 19th 06 06:47 PM
Comparing values in two columns and displaying missing values in n cpetta Excel Programming 1 April 2nd 05 06:18 AM
Help: Comparing two values woknick[_7_] Excel Programming 3 August 5th 04 04:15 AM
Comparing Values Todd Huttenstine[_2_] Excel Programming 7 December 1st 03 06:37 AM


All times are GMT +1. The time now is 12:58 AM.

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

About Us

"It's about Microsoft Excel"