Creating a Point of Sale System in Excel

Hi all.

Is the below possible in exel?

I have an online store.
I use Exel for my accounts and to keep track of orders.
The way i have my Exel set up now is the following:

I have each sale on a row - Starting with the sale date, sent date, customers name etc.

Then i have 3 cells (item 1, Qty, then the price shows automically) Then i have another 3 cells for item 2. and then another3 cells for item 3.

So i have about 6 lots of these 3 cells inline - Then at the end of the row the total cost, how much i sell it for, profit etc.

If the customer only buys 1 item i just fill out the first 3 cells. If they buy 3 items i fill out 3 lots of these 3 cells.

If they buy more than 6 items then i cant really fill it out proberly as i only have 6 lots of these 3 cells.


OK so the question is:
Can i set up a spreadsheet so i enter the date, customers details etc on 1 side.

On the other i enter the product details wheather there is 1 prodoct or 10 - Enter them like as shown.

Then somehow click a button - Have all that info record on another Sheet in a row - So i can check past orders.

And have the variables on the page reset so i can enter another order?

Because there is not a specific amount of items per order, im not sure how to do it?

Thank you =)

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

Yes, it could be done, but it would require VBA. And you could put the information out to one row, in which case I’d advocate putting the totals out first before the individual items.

Personally, I would recommend separate rows for each line item, repeating the customer information. You could use COUNTIFS and SUMIFS to count and total the line items.

As this is more a build it from scratch scenario, rather than help fix, you should consider the Commercial Services sub forum.