Ms excel or word help(data entry like form)

[noman786]

Help me urgent plz excel ya word mein aysa koi function ho k data enter karne par sheet per khud ba khud copy hojaye
for example: Aysa option ho k name,amount,remarks,total ki jaga par sirf likhte jaye aur add karne par wo sheet par bi copy hota jay like data entry but from option not direct in sheet. Plz guide me!
ok i try gain

jese picture 2 me agr data enter kare ge ti picture 1 mein wo show hota jayega ye poochna hay mujhe plz help me bcoz iss template ko pasward laga howa ha so edit nahi hota ye plz help me

[myumair]

Help me urgent plz excel ya word mein aysa koi function ho k data enter karne par sheet per khud ba khud copy hojaye
for example: Aysa option ho k name,amount,remarks,total ki jaga par sirf likhte jaye aur add karne par wo sheet par bi copy hota jay like data entry but from option not direct in sheet. Plz guide me!

didn't understand ur question properly

u may use excel formulas to do dis , please clear ur exact problem

[Omer27]

Apke Question ki Bilkul Samajh nahi lagi.

[noman786]

Apke Question ki Bilkul Samajh nahi lagi.

now check plz

[noman786]

محترم اپنی بات کی ذرا وضاحت کر دیجئے کہ آپکو کیا چاہئے. فارمولاز ایکسل میں لگتے ہیں

ab aap check kare hope samaj ajayge ga

[noman786]

didn't understand ur question properly

u may use excel formulas to do dis , please clear ur exact problem

u also check plz gain

[waqas urdu]

ya vba ka through ho ga jisko vba ata ho wo kar day ga ya

[noman786]

ya vba ka through ho ga jisko vba ata ho wo kar day ga ya

dear! ye vba kis bala ka name hay?

[syar]

salam::

Please see the attached "samplebook". for example Agar aap sheet b m entry karte hai aur sheet a k drop down m name select karain tu aap ka baqi record khod aa jae ga. Aap file dekhain agar aap samajhte hain k aap ka masla hal ho sakta ha tu apna data ka sample dain

regards,

[saqib rashid]

noman ka jo sawal hay me ap ko sab ko samjhata ho k wo kia kahna cha raha hay

naman bhai ka matlab hay k wo excel par 1 form bana na hay us form ya option ho
1 name
2father name
3class etc
or wo us form me entry kary jo data wo enter kary wo khud ba khud Excel sheet par ajay


like Ms Acces ham ms acces par form bana sakty hay jo data enter karty hay wo khud ba khud save hota hay sheet par

[noman786]

salam::

Please see the attached "samplebook". for example Agar aap sheet b m entry karte hai aur sheet a k drop down m name select karain tu aap ka baqi record khod aa jae ga. Aap file dekhain agar aap samajhte hain k aap ka masla hal ho sakta ha tu apna data ka sample dain

regards,

yes! u did it lakin my dear mujhe iska tariqa maloom karna hay k ye kis tarah hota so mein apni marzi ka record arrange kar sako agr aap step by step mujhe samjha dein boh mehrbani hogi bro, thanks a lot!

[noman786]

noman ka jo sawal hay me ap ko sab ko samjhata ho k wo kia kahna cha raha hay

naman bhai ka matlab hay k wo excel par 1 form bana na hay us form ya option ho
1 name
2father name
3class etc
or wo us form me entry kary jo data wo enter kary wo khud ba khud Excel sheet par ajay


like Ms Acces ham ms acces par form bana sakty hay jo data enter karty hay wo khud ba khud save hota hay sheet par

right dear! lakin mein ye sab excel mei hi karna chahta hon not in accesss so plz tell me in simple way thanks