Multiple workbooks consolidated into single master sheet

[TRazzo]

I am trying to track cabinets through our shop. I have a master sheet that will be updated from 5 users with identical worksheets that pulls data from the master sheet when opened so they have the most current data. The problem is when one would update it will overwrite all others new data. is there a way to consolidate data from 5 users to one master sheet without one overwriting the others data?

[davesexcel]

More details are required for a solution.
How are these other wb's access the master workbook and updating it?

[daboho]

Maybe like this

Please Login or Register  to view this content.

[davesexcel]

@ daboho,
What is your code supposed to do?

[TRazzo]

I have a master sheet that I do the updating on, adding new data to. It has many formula's in it so I copy and paste special the data into another sheet that all of my individual user's worksheets access when they open (by a macro), so they always have the most current data available. The issue I have is if user 1 updates their workbook (which all they do is put an X in one cell and it then generates a datestamp in another
) and saves back to the users master worksheet, then user 2 does the same thing then it will overwrite user 1's data. It would work fine until 2 users open their workbooks at the same time an then try to save. I have done a ton of research on this and may have found an answer, in merging workbooks but I have to have everything identical and can have no formula's and i need one to datestamp on the users worksheet. I have some idea's I can work on today. I have way too much time into this.

[davesexcel]

It would be nice if you could not touch the master workbook, but only use the other workbooks to gather or send information to the master workbook.

With the other workbooks, if you require information, you can use code to open the master and get the information then close the master.
If you want to update the master, you can open the master and update it from the other workbooks, then save and close the master.

This way the master would virtually always be closed.

[TRazzo]

After many hours of scouring online I finally got it Figured out. And yes, the master does not get touched except by me to add new data. I learned how to use Merge and Compare workbooks, and it works perfectly. thanks everyone!