We need to have a spreadsheet created that can be used by multiple departments to manage our product range. Currently the information is entered at sku level however we also need the same information condensed to item level for certain departments. We expect this will be using look up and are open to additional tabs being add to allow for this. I have attached the spreadsheet below. There will be work done to this spreadsheet so that all product on this will show a sku per line before we hand this over for development. There will also be an instance where a item will have multiple prices, eg size or colours are different prices. These items will need to remain at sku per line. Please see the example attached. I look forward to hearing from you.