0
I have one document in excel that has a list of product with corresponding codes. 60 stores all have a copy of this excel sheet and they enter data in cells next to the product. I want to link all these sheets so than if I add a new row and product to the "master document" right in the middle it will add that row or every other sheet with whatever format I am using while moving the data they have entered to keep with the corresponding item they entered it for. Basically I add a new row in my document and it creates a new row in a corresponding document.
You need a database to do this effectively. – wbeard52 – 2015-06-14T14:12:28.627