Random rows being overwritten on 'data store' workbook after copying from input workbook

Hi All,

I have a problem with something I created using all the tips you guys have provided from the forum.

I have two workbooks; one for inputting quality assurance scores and one which has the scores stored. They are copied over using a simple bit of code

“Windows("Main.xls").Activate
Range("B4").Select
Selection.Copy
Windows(" DataStore.xls").Activate
Range("E" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Paste:=xlPasteValues”

I use this as each cell corresponds to a cell on the data store workbook, but has to be on a separate workbook due to sensitive information used in the check.
The process works 95/96% of the time but it seems randomly when checks occur instead of finding the next available row in the data store, it selects a random row and overwrites that. This has happened to 3 rows a total of 4 times (twice on row 51) out of 220 checks.
What on earth could be causing such weird and unpredictable errors?

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...-workbook.html

Thread Closed.