Information from userform overwriting data previously entered by same userform

I can't tell for sure, but something that I'm curious about is this.
You have this statement and another one farther down that looks similar but references sheet5

Please Login or Register  to view this content.

What's the tab name of these sheets and why do they need to be activated?
You start a with statement but don't seem to be using it. You say with sheets ("log"), but then keep referring to sheet("log") by name?
You do the same with sheets("work").

Okay I guess I wasn't clear, my fault.
You have these two statements.
Sheet4.Activate
Sheet5.Activate
What are the tab names of these sheets?

Originally Posted by ciresuark

Thank you for the reply. The userform asks if there is additional work that needs to be completed. If the box is checked the information will feed to the work tab, and the log tab. The log tab is a running list of information. The work tab is for anything that needs additional work. Hope that makes sense.

Try this and see if it works. Save your old code just in case. You might just want to try this on a copy of your workbook to make sure everything is okay first. I can't be sure how well this will work without having your actual sheet to test it on. If you still have problems and can share the workbook that would be better.

Here's what I am thinking.
If old data is getting overwritten that tells me the problem may lie in the way your code is determining which row is the last row with data.
Your code is using the COUNTA function on Column A, which counts non blank cells, if you have blank cells somewhere in your data in Column A this may cause issues. I used a technique that goes down to the very bottom of the worksheet in Column A and comes back up and stops when it hits a cell that is not blank. There may still be problems with this because I can't see your data and I don't know if Column A gets data every time, if not and one of the other columns always gets data we should switch to that column when determining the last data row. In other words in the last row of your data Column A doesn't have an entry for some reason but Column B etc does. Then the next set of data will overlap by one row.

Please Login or Register  to view this content.

My pleasure.