i am having two worksheets

worksheet1

it is having some employee details like

empid name address salary............
11 dravid hydrabad 50,000

now i am in worksheet2

if i give empid as input in sheet2 it should fetch the equal rows from
sheet1. and place the rows in sheet2 active coloumn.
and when i save the worksheet2 i want to transfer sheet2 's details in
to sheet3 one by one.

note : it is not possible to sort the worksheet1.


--
ananthmca2004
------------------------------------------------------------------------
ananthmca2004's Profile: http://www.excelforum.com/member.php...o&userid=29055
View this thread: http://www.excelforum.com/showthread...hreadid=487866

Ananthmca2004,

The first part of your request, taking data from Sheet1 to Sheet2 based
on the employee number, looks like use of the VLOOKUP function will do what
you need. Take a look at that using Excel's Help feature.

The second part, transfering data from Sheet2 to Sheet3 when you close
the file, will require use of a macro which will have to be tailored to
exactly the information and format that you want.




"ananthmca2004" wrote:


i am having two worksheets

worksheet1

it is having some employee details like

empid name address salary............
11 dravid hydrabad 50,000

now i am in worksheet2

if i give empid as input in sheet2 it should fetch the equal rows from
sheet1. and place the rows in sheet2 active coloumn.
and when i save the worksheet2 i want to transfer sheet2 's details in
to sheet3 one by one.

note : it is not possible to sort the worksheet1.


--
ananthmca2004
------------------------------------------------------------------------
ananthmca2004's Profile: http://www.excelforum.com/member.php...o&userid=29055
View this thread: http://www.excelforum.com/showthread...hreadid=487866