Need to merge separate workbooks frequently.

[taylorsm]

Right now my team uses one shared workbook on our network to keep track of all our information. However, it is terrible. It is always glitching or causing problems. The issue has something to do with it being a shared file on the server, but outside of that I do not know. So the only option I can think of is to have each person maintain their own copy and then I merge them all together at the end of the day. I've attached a blank workbook of what each would have. There should be any worry about one employee overwriting another's because each employee has their own team to watch. In the workbook, sheets Prod totals, Tracker, DCMR, 8,7,6,5,4,3,2,1, will be merged. the 1-8 represent the employees. The #sheets represent a daily log. Tracker is a list of names of all the teams. Merging employee's #2 sheet with the master's #2 probably isn't difficult. But the Prod total and Tracker consists of all users inputting on the same sheet but shouldn't be overwriting each other.

Is there a way to import new data, give an alert if it is about to write over anything existing, and be relatively quick.

[MarvinP]

Hi taylorsm,

I'd be looking at Power Query to do your problem. You can put all those workbooks into a single folder and roll them together too. Read about it at:

http://www.contextures.com/excelpowe...inetables.html

If PQ is not an option then VBA is the next possible method, and much harder to do.