Whiskey/Wine journal: Solutions to make data entry easier?

cyrus561

New Member
Joined
Jun 30, 2010
Messages
5
I am hesitant to post this, but my searches on the forum/web are coming up fruitless...

I am trying to create a Whiskey/Wine/Beer journal.

I have created a spreadsheet that will allow me to enter the info/rating/attributes to each drink and develop a visual (radar graph, color scale, rating) representation of it. So far all of this has been manual. For example: I have to cut and paste one group for a new entry and replace/reassign all the cells.

I would like to create a Data Entry Form or User Form to aid entering information. I’m getting the basics of the User Form, but what I am having difficulty with is making it look the way I want to.

Is there a way to make the entered data/objects appear in the desired locations, rather than straight across one row?

Is it possible to create graphs (particularly Radar Graphs) through this method?

I have attached a link to what I have so far. It should provide a better reference as to what I’m trying to achieve. If you guys can think of anything more efficient, I am open to hear it.

Thank you in advance! This forum has helped me in so many ways prior (especially with this project).

Drew

Feel free to use the journal as your own. The Wine worksheet is lacking, but the Whiskey and Beer pages are functional.

http://docs.google.com/leaf?id=0BzS...hjMWMtMDUxMjMxZjQyZDlk&hl=en&authkey=CL2t3oEM
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top