Hi,
I have a workbook in which there is a sheet (ERP_Query) which is querying our ERP System. It returns data on works orders for our production lines (Production Line, Item no, Description, delivery date, pack count etc). I'd like to create a sheet for each of our 3 production lines on which the user can select from a drop-down the next works order he is going to run and the relevant information will be returned. There is a sheet per production line.
The WO is a value made up of the concatenated delivery date and item number. I can obviously create data validation by list and use the WO column as the source, however I'd like to only see works orders for the production line of the sheet I am on, secondly on the drop down list I'd like to see the date/item no combo, but when it returns the data to the production line sheet, I'd like to see part no in one cell and the del date in another. I hope that makes sense
I have a workbook in which there is a sheet (ERP_Query) which is querying our ERP System. It returns data on works orders for our production lines (Production Line, Item no, Description, delivery date, pack count etc). I'd like to create a sheet for each of our 3 production lines on which the user can select from a drop-down the next works order he is going to run and the relevant information will be returned. There is a sheet per production line.
The WO is a value made up of the concatenated delivery date and item number. I can obviously create data validation by list and use the WO column as the source, however I'd like to only see works orders for the production line of the sheet I am on, secondly on the drop down list I'd like to see the date/item no combo, but when it returns the data to the production line sheet, I'd like to see part no in one cell and the del date in another. I hope that makes sense