EE Solution 2 : Using a Form to Populate a Table
See attached for worksheet functions (non vba) approach
Attachment | Size |
---|---|
Cheese.xlsx | 23.62 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 523 guests online.
New Excel Experts
Current Excel / VBA Jobs |
EE Solution 2 : Using a Form to Populate a TableSee attached for worksheet functions (non vba) approach
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
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