Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Data entry method

Posted by Brett on July 13, 2000 12:09 AM
I am collecting in paper forms which will be used to analyse beer quality in around 100 pubs. The forms contain the following information:
Pub:
Location:
Date:
Surveyor: (there are 10 different surveyors)
Score: (our of 5)

What is the best way to enter these into Excel? I was thinking of one form per row with the above headings in columns.

It would be nice to have list boxes, to ease the entry process (a number of pubs will be surveyed multiple times)- is visual basic the only way here?

I will be using pivot tables to look at:
Overall quality of ale over the year,
Range of surveyors visting a particular pub.

The pubs themselves are in an Access database. I am not sure if that application is where I should putting this together.


Re: Data entry method

Posted by Brett on July 17, 0100 12:40 AM


Many thanks Ada - I'll give it a go. I am surprised that you were the only person to reply to my message. Perhaps it was too trivial for MB readers?
Brett


Re: Data entry method

Posted by Ada on July 14, 0100 4:19 AM


Brett
Re your question about input boxes.
VBA is not the only way - it could be done with Excel's data validation tool.
In the help file, look up "Specify the valid entries for cells > Restict cell entries to the data from a list"
Ada


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.