I've been working on this project for a while, and I just can't seem to get it working consistently. It was started by someone else, I've been trying to get it working, but data will get duplicated or not transferred at all. Here's the summary:

We have a series of about 20 workbooks, one for each of our machines, where the operators log various hourly data points. Each sheet has a row for each hour, each row has between 14-24 columns depending on the machine. When the operators are done filling out their data for an hour, they click a checkbox at the end, which launches a sub to transfer the data to a second workbook. The second workbook groups machine types together and permanently stores the data; so for example, we have three Automation Machines, AM1, AM2 & AM3. Each has it's own log workbook, where the user logs the daily data, then the data is cleared at the end of the day. There will be a separate Automation Machine data sheet with three tabs, one for each machine, and every hour, the operators transfer their data from the individual hourly logs to the grouped data workbooks.

So the method I'm using to transfer the data works...mostly. I get double-posted data occasionally, and completely skipped data sometimes. I know part of the issue is our network, it sometimes has little 'hiccups', so I've tried adding checks after the data transfer, and I'm. This is what I use (roughly, trying to simplify as much as I can):

Please Login or Register  to view this content.
I actually have the write data portion in a separate sub, and it has to enter a bunch more columns of data, but this is the gist of it; I write from a cell in the current sheet to one in the target workbook. I also have error handlers to detect missing data, to detect if the target sheets are in use, and other things such as that. At the end of this code, I repeat the Check Data lines, as a test to make sure the data did transfer. We thought that sometimes the target sheet was not saving properly, so I started closing the target sheet, then reopening it again before doing the Data Check. I still have problems getting it to work. So any thoughts, corrections, or alternate methods would REALLY be appreciated. Thanks!