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
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
Aise tu bohat se functions/method hain. Agar aap screen shot de sakee tu bahtar andaz m aap ki madad kar sakoon ga.
regards
shukriya!
Mein b is k mutaliq janana chahta tha.
koi batadey ye sawal jo uper pucha gya hai
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....
afzaldir Allah aap ko Khush Rakhye or Izat shohrat or Hadayat ata Farmaye Ameen
Jazak Allah
Mera Peghaam Mohabbat hai jahan tak pohanchy
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.....
wah kia baat hai.
Great
Bohat Arsay se Talaash thi is ki.
Jazakallah
nice sharing
nice sab ka thanx samj a gyi
Bookmarks