sheet 1 ka dusri sheet py formula

[farooq_18]

main yha phuchna chta ho k mian ny sheet 1 main koi data lhka hai main sheet 1 main koi chnge kro tu wo 2nd sheet py b changing ho jy asa koi formula hai kia plz help me

thanx

[syar]

Aise tu bohat se functions/method hain. Agar aap screen shot de sakee tu bahtar andaz m aap ki madad kar sakoon ga.

regards

[Ganxtr]

shukriya!
Mein b is k mutaliq janana chahta tha.

[cute_laiba]

koi batadey ye sawal jo uper pucha gya hai

[afzaldir]

No problem.....
For Example
Sheet1 > A10 per hum ne Farooq likha hey....
Aur hum chahte hein k Sheet2 > A10 per wohi name aa jaein jo Sheet1 hey likha hey. Phir hum ye b chahte hein k ager Sheet1 > A10 mein change ho tu Sheet2 > A10 mein b wohi change ho.....
Solution:
Sheet2 > A10 per
=
likh kar, sheet1 ko click kar k is mein A10 ko click karein phir Enter key press karein.....
YA
Sheet2 > A10 per likhein:
=Sheet1!A10

Is se hum Sheet1 > A10 per jo b likhein gay wo Sheet2> A10 mein b update ho ga.....
ak list k liye Sheet2 > A10 per ooper wala kam kr k us ko neeche ki taraf drag kar dein.
Thanks....

[Sword]

afzaldir Allah aap ko Khush Rakhye or Izat shohrat or Hadayat ata Farmaye Ameen
Jazak Allah

[meerabkhan]

[syedshoaib]

yeh tu bohat hi asan hai


= yeh press kro kisi bhi cell per or jis sheet per jana chahte ho wahan ja kr enter kr do so simple.....

[ishaq1]

wah kia baat hai.

[javedjee2005]

Great
Bohat Arsay se Talaash thi is ki.
Jazakallah

[Mr Dark]

nice sharing

[farooq_18]

nice sab ka thanx samj a gyi