Hi

I am looking for a help in my case where i have an excel sheet. On
Sheet1 i have one column and 6-7 rows each having different text .Now
on sheet 2 of the same file there is a column where i want to populate
the value of the text selected on sheet 1.

eg
sheet1 has 6 diff entries like A,B,C,D,E,F and sheet 2 column is
empty.

Suppose i select B(Second Row) on sheet1 and go to Sheet2 then the data
populated there should be B, similarly if i change and select C(Third
Row) on sheet1 and go to sheet2 then teh data populated there should be
C.

Help me Pls ...

Hitesh


--
Hitesh_sethi
------------------------------------------------------------------------
Hitesh_sethi's Profile: http://www.excelforum.com/member.php...o&userid=33851
View this thread: http://www.excelforum.com/showthread...hreadid=536284