Hi
I complete a parts order sheet everyday which could contain several lines under the same order number. The line has the following data; Registration, Part number, Part description, Quantity, the date and order number are also on the sheet.
What I need to do is link the lines with the date and order number to one master sheet that records all the data and when a new order is created all the lines are added to the master so eventually the master can show several orders then I can easily find out what has been received and whats on order.
How can I do this?
Many thanks
Mick
Bookmarks