Excel : Validation Main Dosri Sheet Say Data Use Karna

[Mubashir Aziz]

Aksar dostoon ko Validation main Dosri Sheet Kay usage main mushkil paish aati hay. Aaj Main Aap ko Iss Ka Hal Batata Hoon .... Leekan Aap Dost Apni Problems Ask An Expert Main Title Main Excel Likh Kar Bhi Pooch Saktay Hain ....

Farz Kia aap kay pass Sheet2 Main List hay jiss key range A1:A50 Hay aap

1. Aaap Range Ko Select Krain
2. Aab Insert --> Name ---> Define Par Jain Gay to ek Dialague box open hoga
3. Aap "name in Work Book" walay box main Koi "name1" likh dain

Lain G aap ka ek kaam ho gya

Aab Sheet1 main Ja kar

1. Cell A2 par rahtay hoye Data-->Validation-->List---> Allow Main List
Select karain

2. Aab neechay Source Main =name1 likh dain

Janab aap key dossri sheet main mojood List Sheet1 main aa jay gi .....

Duaoon Main yaad rakhain ....

Mubashir Aziz

[farhanali560]

بہت خوب بھایی جان

[brktmirani]

thanks for your.

ye aap sab log itne ache kyon hain

koi bataega

[BossisBack]

moved to GD

[Mubashir Aziz]

Aap logoon key guideline kay liye main excel file bhee attach kar raha houn .... aap ko mairay meeting room walay schedule ko samjhnay main bhi aasani ho gi .........

[kamibest]

Good Mubasshir Bhai Very Nice

[Mubashir Aziz]

thanks Kami