Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
collecting sales data
First thanks for the help. Here is my question.
At the time of sale, I input data for each sale as follows, simplied version: A1 = Receipt number A2 = Buyer name A3= Total A4= Date I need to collect cerain sale's data within the spreadsheet, build a database of sales. I can prenumber the receipts in the database and use an IF statement with a circular reference (iterations) based on the receipt number. However, if I mess up on my input sequence (forget to advance the receipt number for new entry), I mess up the previous sales entry. Just wondering if there is a simplier or safer way of doing this. Thanks again, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help collecting data. | Excel Discussion (Misc queries) | |||
help collecting data please! | Excel Discussion (Misc queries) | |||
Collecting data from worksheets. | Excel Worksheet Functions | |||
collecting data | Excel Discussion (Misc queries) | |||
Help with collecting data from a spreadsheet | Excel Discussion (Misc queries) |