Compare Sheet1 value to values in Sheet2 Column A

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 363

Compare Sheet1 value to values in Sheet2 Column A

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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 Update elements from Sheet1 with Sheet2	[email protected]	New Users to Excel	3	November 27th 07 04:27 PM
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated	pano[_3_]	Excel Programming	2	October 28th 07 02:32 PM
Compare sheet1 with Sheet2	Mike	Excel Programming	1	March 1st 07 07:20 AM
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2')	Lawrence C H Tan	Excel Worksheet Functions	0	January 19th 07 08:29 PM
VALUES CORRESPONDING FROM SHEET1 / SHEET2	R.Deurs	Excel Programming	3	May 17th 04 01:52 PM

All times are GMT +1. The time now is 09:04 PM.

Menu

About Us