Find and Match in one worksheet and get data (Very Urgent)

Posted to microsoft.public.excel.programming

Lolly[_2_] Lolly[_2_] is offline

external usenet poster

Posts: 28

Find and Match in one worksheet and get data (Very Urgent)

I have two worksheet named sheet1 ans sheet2
My sourcedata in sheet one in two columns is as follows
V1 V2
30 100
31 100
- 206
- 323
30 202
31 203

If these two value matches in both sheets i.e sheet1 and sheet2 then I have
to copy the data from sheet2 to sheet1 in a row corresponding to that value

Any help will be greatly appreciated

Thanx in advance

Lolly
--
Kittie

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
SUMPRODUCT - MATCH CALL DETAILS 2 FIND RELEVANT EXTN - URGENT PLS!	Twiggy	Excel Discussion (Misc queries)	0	February 22nd 10 07:31 PM
Urgent:Find match between two worksheets and copy to another sheet	guru	Excel Worksheet Functions	1	September 21st 09 07:41 PM
Using Match to find value on worksheet	Dkline	Excel Worksheet Functions	3	March 4th 09 01:28 PM
Using Index & Match functions to find data on separate worksheet.	Andrew Duncan	Excel Worksheet Functions	4	July 3rd 07 11:54 AM
Transfer cell data from one worksheet to another === URGENT	rajesh	Excel Discussion (Misc queries)	1	December 5th 05 02:40 PM

All times are GMT +1. The time now is 12:21 PM.

Menu

About Us