I have months worth of cash register receipts in front of me from an assortment of food and beverage sales which need to be manually entered into an excel database. My current means of data entry is through a lookuplist and input sheet with drop-down menus for each product, date, and location of sale.

Information that needs to be in each row of the database is: sale date, location of sale, product description, quantity sold, price of item, classification as food or beverage, and total cost.

I tend to do 1 location and day at a time, so i could easily just copy down the date and location through the corresponding cells.

However, I'd like to find a way to assign each row of product/price/classification a letter or number so that I could just go down the list and type for example:

1 = hamburger $2.99 Food
2 = large drink $1.99 Beverage
3 = ...
4 = .....

so that i could just go down the list and quickly enter the number and have the entire row show up for that product - and i'd only have to go back to enter the quantity sold for each.

Please if there is a way let me know! Thanks