speeding up code that is super slow

Ok, I'll try that. Do you have a suggestion for the date stamp at the end of the newly copied lines on the completed sheet?

As far as the network security goes, it simply tells me that I am removing the workbook from being shared and asks if I am sure or not. It's a pop up that has a "yes" or "no". Is there a way to force the macro to "click" yes every time, so I don't even see the popup?

The reasoning is that I submit an order and it populates this sheet for our shipping and receiving guy or "traffic" dept. The spreadsheet runs open on his puter all day long and when a shipment comes in, he can fill in the appropriate cells. When the job is completed, he types in "yes". It updates every 5 minutes or when saved, so because I keep the same spreadsheet open so I can schedule installations or provide customers with job status if they call, I am the one who clicks the "completed" button when I see that a job or group of jobs has been done. So essentially, I am the only one that sees that popup and since I always click "yes" to acknowledge that the spreadsheet will not be shared any more, it would be nice to not even see it.

Originally Posted by JBeaucaire

This line of code is looking at column A on the "completed" sheet to spot the "last row" of current data and note the "next row" for the target later:

NR = wsI.Range("A" & wsI.Rows.Count).End(xlUp).Row + 1

I added another sheet reference into that, underlined above, try that first.

If column A is a bad column to use for that test, then change that to the correct column to check, column B or column W, whatever, then try again.

I have no comment on your shared workbook issue, overcoming network security is often no small feat. Perhaps a new thread to specifically address that question without the need for the full macro as it's not really related to that.