N
niels.jessen
Dear friends,
I hope I can explain this problem I have;
For production planning purpose I have developed an worksheets, where I
by entering an item number and a volume, will get a breakdown into
details like packaging machine, production line, raw materials needed
etc. Works nice with manual input in the defined cells: I have 30 empty
fields where I can enter Item number and volume. The worksheet returns
a number of details.
Orders are generated in our old ERP system where the print outs of open
orders can be exported as HTML and therefore be open by Excel.
I want to import these order into the above mentioned planning
spreadsheet.
Problems I have encountered;
I cannot VLOOKUP as I do not know which item nr I look for. We have 200
item numbers (SKUs) and maybe only 30-50 are in order.
I cannot SUMIF without listing all 200 SKU numbers and accepting the
approximately 150 who will show up with '0'.
Any suggestions on how I can proceed?
I hope I can explain this problem I have;
For production planning purpose I have developed an worksheets, where I
by entering an item number and a volume, will get a breakdown into
details like packaging machine, production line, raw materials needed
etc. Works nice with manual input in the defined cells: I have 30 empty
fields where I can enter Item number and volume. The worksheet returns
a number of details.
Orders are generated in our old ERP system where the print outs of open
orders can be exported as HTML and therefore be open by Excel.
I want to import these order into the above mentioned planning
spreadsheet.
Problems I have encountered;
I cannot VLOOKUP as I do not know which item nr I look for. We have 200
item numbers (SKUs) and maybe only 30-50 are in order.
I cannot SUMIF without listing all 200 SKU numbers and accepting the
approximately 150 who will show up with '0'.
Any suggestions on how I can proceed?