ADDING PRICES ON THE SAME CELL BY MACRO

[qwertyqweras]

I HAVE DESIGNED A SPREADSHEET SO WHEN PEOPLE ORDER SOME FAST FOOD, THE WORKERS CAN USE THIS SPREADSHEET TO CHOOSE WHAT THE CUSTOMER WANTS FROM THE DROP DOWN LIST. HE CAN CHOOSE HOW MUCH OF THE FAST FOOD HE WANTS AND IT WILL TELL YOU THE COST. AT THE BOTTOM OF THE SHEET THE 'TOTAL COST' IS CALCULATED.


I WANT TO KNOW HOW TO GET THE TOTAL COST ONTO THE OTHER SHEET SO IT WILL CALCULATE HOW MUCH MONEY IS MADE ON THAT DAY. I HAVE A MACRO WHICH RESETS THE PRICES FOR THE NEW CUSTOMER. BUT AS THE MACRO IS USED I WANT THE PRICE OF THE CUSTOMER BUT WHEN A NEW CUSTOMER ORDERS I WANT THE COST OF THE FIRST CUSTOMER TO ADD UP TO THE SECOND CUSTOMER.

PLEASE HELP ME.

 

[SydneyGeek]

Hi, welcome to the board. Would something like this do the trick?

Sub TransferData()
    'transfer current values to Summary sheet
    Sheets("Summary").Range("A65536").End(xlUp).Offset(1, 0).Value = Date
    Sheets("Summary").Range("B65536").End(xlUp).Offset(1, 0).Value = Sheets("Purchases").Range("D29").Value
    'clear other values here to reset for new customer
    '... etc
End Sub

BTW... please don't use all caps in your posts -- it's not that easy to read, and it looks like shouting :wink:
Assumptions:
Your total for each transaction is in D29 of Purchases.
You are transferring summaries to Summary sheet; Col A is date and Col B is total.

Denis