Hi
I have attached file where multiple sheets are there
In Food Purchase sheet I used Drop down in B column
Same Fields are available in my Report Sheet from cell B 198 to B 212
I want to fetch sum for those fields from Food Purchase sheet in column I (marked Red) I 198 to I 214
eg in food purchase sheet total cheque amount for DRY STORE / GROCERY is 19500/-
then it should reflect in Report sheet in cell I 98 marked red
Same time in Food Purchase sheet G3 value will greater than D3 (Marked Red),
then it should give Error alert massage for Budget crossed via Data Validation
Please help
Atul
Bookmarks