I am trying to create a document which will keep track of products arriving and when they will arrive,
i would like the product, stages of production and date in which the stages change.
I would like one master sheet and then individual sheets for my customer and when i change the date of arrival of a product it will look for this product on their individual sheets and change their date to match the master
I would like it to link up with other sheets where people can see there own stock, eg. if i change product A to in production it will then look for that product on a different sheet and change the status and date to match the master sheet.
i don't know if this is possible at all or where to start???!!!