Microsoft Excel Help Needed From ITD Experts....

Assalam-u-alaykum

Doustoun Mujhe Ms Excel Ke Hawale Se Aik Baat Poochni Aur seekhni Hai , Umeed Kartha Hun Itd Ke Pyaaare Members Meri Help Karenge ..

Baat Yeh HAi----

Mujhe Batayen Ms Excel Mai Aik File Ko Doosri File Se Kaise Link Karthe Hain ...???

Matlab Yeh KE MEre Pas Aik File Hai Jis MAi Production Record Kartha Hun Aur
Doosri File Jis Mai Main Stok Update Kartha Hun Uss Production Ka ..

Tesri File Jis Se Mai Billing Nikaaltha Hun Jo Stock Hai..

Ub Mai Inn 3noun Files Ko Aik Dusre Se Connect Karna Chah Raha Hun KE MAi Sirf Production Enter Karun Mai Aik File MAi Aur Doosri File Ka Stock Aur Billing FORMULA KE Zarye Automaticaly Update Hotha Rahe ....