Cell H5 m
Code:
=IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$C$5>SUM(sheet1!A$5:$E5),sheet1!$E5,sheet1!$E$5-SUM(sheet1!A$5:$E5)))
Cell H6 main aur copy down as far as required
Code:
=IF(Sheet2!$C$5<SUM(sheet1!A$5:$E5),"",IF(Sheet2!$C$5>SUM(sheet1!A$5:$E6),sheet1!$E6,Sheet2!$C$5-SUM(sheet1!A$5:$E5)))
may be this will help you. Enhance this formula a bit as per your requirement. agar phir bhee problem ho tu bataye ga.
Waise brother aap apna purana thread
Code:
http://www.itdunya.com/t258601-2/
bhe check kar lain. Ye tu mujh ko abhee yad aaya ha.
regards
Bookmarks