Hi All,

Please can you help me on some ideas regarding a spreadsheet i need to create. Im pretty new to Excel so please bare with me.

I have a small business and keep written records, calculating and invoicing customers manually. I have started to use excel and wish to automate my invoices.

I record daily amounts in columns and rows like below. (note the vlaues are in Kg)

Monday
bananas apples oranges mangoes kiwi
Peter 10 7 9 6 1
John 5 7 6 4 7
Scott 6 5 7 3 2
kidd 7 2 6 2 3
holland 3 2 7 8 9

Then i use a price list to calculate the amounts by multiplying the weight amount against the price list below.

price list
bananas 1.59
apples 1.2
oranges 0.95
mangoes 2
kiwi 3

I want to know the best way to record these daily amounts and i want to generate an invoice at the end of the week and hold a record of 52 weeks in a work book.

Maybe in the end look at the best time of year that apples sell most or which month banans are best sellers.

Please can someone give me some ideas or point me in the right direction.

Thanks for your time.

Aboo