Hi Everyone! I hope everything is OK.
I here to ask for your kind help regarding below excel sheet sample
I have a form with a list of Fruits & Vegetables and i want to have the Total Amount of each fruit on the last column by just changing the Date shown above.
On the second excel sheet, there's a table that has the list of all items and the price varies with the date shown above.
So when i change the quantity and date on the first sheet, the total amount will automatically change as per the date.
Please help. Thank you very much!
FIRST SHEET:
LIST.jpg
SECOND SHEET:
Fruits&Veggies.jpg
Bookmarks