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
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