MS Excel help for a reative beginner?

[750turbo]

Looking for some guidance in what I would say was the creation of a "form", with Drop Downs, allowing the user to select the data, and it is displayed elsewher on the form.

Even a link to some sites that show how this is done?

This is only for users to help calcullat electricity costs for a specific piece of equipment to help them know whats in the pipeline come October.

Something like this? (Ignore the red boxes please)



Thanks

Note to self - Always check your speeling...

Edited by 750turbo on Friday 2nd September 17:41

[21TonyK]

There are far more experienced people than me who can advise but having not used Excel in anger for 20?+ years I'm starting to get back into it and just created pretty much what you are describing.

In my instance the user selected a product and it populates a sheet with the details, the category determines the items shown which in turn take the details from a linked data source which updates and varies day to day (pricing).



If you google excel "forms combo list" you will get an idea.

[750turbo]

21TonyK said:

There are far more experienced people than me who can advise but having not used Excel in anger for 20?+ years I'm starting to get back into it and just created pretty much what you are describing.

In my instance the user selected a product and it populates a sheet with the details, the category determines the items shown which in turn take the details from a linked data source which updates and varies day to day (pricing).



If you google excel "forms combo list" you will get an idea.

Many thanks, but the drop down list is ok, all done.

I just want a front end that looks like a "Form" of sorts, something user friendly, and even a little professional

[Mr Pointy]

Sure your're not an absolute beginner? (Excel joke). There are a huge number of training videos on Youtube & I find just typing into the search box brings up reams of video & trying a few usually gets me one that explains how to do what I'm after:

https://www.youtube.com/results?search_query=excel...

[21TonyK]

750turbo said:

Many thanks, but the drop down list is ok, all done.

I just want a front end that looks like a "Form" of sorts, something user friendly, and even a little professional

So a pop-up "excel userform" ?? ie, a dialogue box that pops up with all the drop downs to populate stuff?

[HappyMidget]

Sod using excel, Power BI desktop is what you need for this for an interactive reporting experience

[750turbo]

Thanks all - Will give the links above a go, although Power BI is way over my head.