Hi,

I need to know the best way to set up a spreadsheet which has product information (i.e name cost, sale price, number purchased, number sold, number left in stock) Every week I check the stock so need to be able to to enter the new current value of the number left in stock.

The every week I buy new stock. Sometimes the stock changes in price.

The spreadsheet needs to also keep track of how much money I should have from the sales of the stock and then therefore the profit made etc.

Thanks