qwertyqweras
New Member
- Joined
- Jan 19, 2005
- Messages
- 1
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.
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.