In sheet <test1, cell A1 enter:
=test!A25

copy thru C1
B1 will hold =test!B25
C1 will hold =test!C25

HTH
--
AP

"dk" a écrit dans le message de news:
...
we like to get data from diffent sheet or work by putting in data cell and
filling the rest of the columns automatically
ex; sheet 1 = test
sheet 2 = test1
sheet <test has in cell a:25 <35 : cell b:25 <50 cell c:25 <70
we will put in sheet <test1 cell a1- A link to sheet <test row <25
then
cell b1 will fill <50 cell c1 will fill <70
please explain we are new user