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