Sheet1.jpgSheet1.jpg
I have (what I think) is a complicated problem here! I've always been successful with my problems on here so I'm hopeful! I want to use the data in the attached sheet, extract parts of it and organise it into something much more simple. Probably into another sheet within the same workbook.
I only want to take data from parts (customer or supplier side) which have not got anything next to it in either the supplier or customer side. The first example of this starts at row 21 where the supplier side has details but there is nothing in the customer side.
I would need 3 "tables" for each the supplier and customer side, organised into location. So 1 for North, 1 for South and 1 for Mids for both customer and supplier side - 6 in total. Within those tables I need it organising into products, whatever that might be. I'd then like it organising into monthly period's with an average price for each month.
My aim is to have a sheet that at a glance tells me you need to buy/sell x number of tonnes for these months of this product in the north/south/mids.
I know I'm asking a lot but if there is anyone who thinks they can help me set it up or knows of anybody that could offer this service I'd be massively greatful. I understand that this sort of service might not come for nothing.
Thanks,
Ant
Bookmarks