EE Solution 2 : Using a Form to Populate a Table

See attached for worksheet functions (non vba) approach

AttachmentSize
Cheese.xlsx23.62 KB

how to make tht scroll bars

Thanks Andys for tht great stuff I had learned lot from this , iam scrachthing my head for those scroll bars where u written Cheese , Milk,yoghurt plese help me on tht .

Thanks SO much

Hi Andy

Thank you so much, this is exactly what I needed, would never have figured it out on my own. Went through it and understand most of it, have some additional work to do with converting the table to a graph, with the drop down form boxes on the graph instead of the Excel sheet. Will shout if I need further help.

Thanks

Great Job Andy

Really great job please tell me how to do this as Iam new to excel how u did it please explain me.
thanks

I included a "notes"

I included a "notes" worksheet to show the sequence of calculations....
If you look up the help file for each function it's easy enough to understand and these are important Excel functions to familiarise yourself with.. They allow us to do things like your project :-)
Learning Excel is about learning the functions and how to combine them to get useful results - That's part of the fun