Compare Sheet1 value to values in Sheet2 Column A

Corey

Guest

Posts: n/a

4th Nov 2007

I am trying to date to no avail to solve this code.

I am trying to compare a cell value (G5) in sheet1 to see IF it is found in Sheet2 Column A

If it is i want to place other values in the SAME ROW in SHeet2
If it is not found, then i want to insert a New Row in Sheet2 and place the data into that new row.

I have not beed able to work out a code to be able to succesfully do this.

Any idea's?

CTM

« Pictures not displaying | delete rows if cell in row contains "a" or "o" or empty »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy rows from Sheet1 to Sheet2 when Column B values equal "X" andColumn C values > 100	u473	Microsoft Excel Programming	2	24th Jun 2010 03:56 AM
Compare and Update elements from Sheet1 with Sheet2	joel.agustin@gmail.com	Microsoft Excel New Users	3	27th Nov 2007 04:27 PM
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated	pano	Microsoft Excel Programming	2	28th Oct 2007 02:32 PM
Compare sheet1 with Sheet2	=?Utf-8?B?TWlrZQ==?=	Microsoft Excel Programming	1	1st Mar 2007 07:20 AM
Show a sheet1 row in sheet2 based on values in col sheet1.A	=?Utf-8?B?TWljaGVsbGU=?=	Microsoft Excel Misc	5	4th Mar 2004 02:52 PM