Home » Forums » Open Source Learning Center » Question and Answer

EE Solution 2 : Using a Form to Populate a Table

Submitted by AndyLitch on 19 March, 2013 - 19:57

See attached for worksheet functions (non vba) approach

AttachmentSize
Cheese.xlsx23.62 KB
‹ How to insert elbow connector across 3 excel charts and put into word doc? Dinamic Variable Memory ›
»

how to make tht scroll bars

Submitted by milind on 20 March, 2013 - 16:30.

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

Submitted by Fatz_Sh on 20 March, 2013 - 11:09.

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

Submitted by milind on 20 March, 2013 - 04:42.

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"

Submitted by AndyLitch on 20 March, 2013 - 07:28.

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

»