PC Review


Reply
Thread Tools Rate Thread

collecting sales data

 
 
=?Utf-8?B?dGp2c2VuaW9y?=
Guest
Posts: n/a
 
      7th Sep 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy sales volume data from sheet 2 to sheet 1 by sales person pm Microsoft Excel Misc 1 4th Nov 2009 09:11 PM
Sales Order to Sales History Data Koomba Microsoft Excel Worksheet Functions 0 2nd Oct 2008 01:09 AM
Linking Sales Order to Sales History Data Koomba Microsoft Excel Worksheet Functions 6 30th Sep 2008 06:06 AM
Collecting data Mary Lee Microsoft Excel Misc 3 20th Apr 2008 12:24 AM
help collecting data. =?Utf-8?B?YnJhbmRvbiByb2xhbmQ=?= Microsoft Excel Misc 5 8th Aug 2007 11:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:49 PM.