Making a simple sales sheet with excel help

[feo2y]

Hi there,



I am looking for a simple excel solution to a relative simple application (i think).

Scenario: My wife attends craft weekends and runs "tabs" for customers in excel. At the end of the weekend she has to cash everyone out. Currently she takes a name, and some other info, then start populating rows underneath with what they purchase.

Problem: The problem is when they check out it is difficult to search through 100 names on one sheet when all the sale items are intermingled between names, then as people pay it gets real messy having to visually differentiate payed and non-payed customers in the single sheet.

Question: Is there a way to have the first sheet with just first names and last names so they can be sorted and then have each name link to another location where the rows sale item information and totals are?
She will need to go back and forth between these two locations often until the customer finally closes out the sales.

Thanks for your help!

Dave