Hello,

I figured out my problem! When I ran another code it moved data to the
end of some of my worksheets and when I got a error message saying to
use control end to find data at the of the worksheet it had some how
moved my data to the last row in my worksheets. So I got a fresh copy
of my workheets tried the new code and it works fine!

Thank you for your help,
jfcby