Hope some one can help please. I have attached a sample spreadsheet.
I have a catalogue of Products from a supplier.
Each product has numerous costs and what I want to achieve is to be able to enter a profit amount for all the products in one cell which will therefore populate the amount throughout the catalogue to all the catalogue.
With doing this the Buy it Now Price will be automatically updated to accommodate the profit.
Products with a Selling Price Less than £9.99 Selling will need an option to include Postage of £3.54 if not the Buy it now will need to be increased to accommodate the profit.
Are as follows
Postage Cost Under 9.99
Sell Price inc VAT
Buy it now
BIN inc ebay fees
With out £3.54 postage
Stock On Hand
100 Hour Burn Time Pilla
A white, pillar candle
100 Hour Burn Time Pillar Candle, Vanilla Fragrance
A white, pillar candle with a single wick in white.