kia excel kisi ko nahi ata

[sabir sami]

mne ye kia hay k Sheet-1 k qty column me jo likha jai wo sheet-2 sale wale column me khudbakhud ajain.......agr yehi pblm hay to pblm solve ho chka hay

nhi yar balance main minus q arah hay agar 300 qty to sale culom main es tarah honi chaye k balance main minus no ho.

[janibaba]

nhi yar balance main minus q arah hay agar 300 qty to sale culom main es tarah honi chaye k balance main minus no ho.

aray bhaiya.......... sheet-1 k QTY column me sheet-2 k Total k cloumn se km figure likhey jainge to minus nhi ayega...

jb apke pass 100 item hongey aur ap se 120 ki deemand ki jai to lazmi baat hay 20 minus me hogi ose pura krney k lye apne total item barhain

[syar]

G1 Enter below formula

=IF(Sheet1!$D$2>SUM(Sheet2!$D$4:D4),D4,Sheet1!$D$2-SUM(Sheet2!$D$4:D4))

G2 Enter below formula and drag down as far as required

=IF(Sheet1!$D$2>SUM(Sheet2!$D$4:D5),D5,Sheet1!$D$2-SUM(Sheet2!$D$4:D4))

Formula tested on your sampl sheet. If there is problem with your original sheet change the reference and ranges accordingly.

regrads

[sohail1966]

Very nice sharing