how to fetch a row and post the row into another sheelt

[ananthmca2004]

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.

[Roland]

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
>
>