Ok I fiqured out the code, there was a "End With" missing at the end. So
that works great, but it's not exactly what I am looking for, although
it's getting me closer.

I want a separate page for each customer, so after my 4th worksheet, I
want to start in alphabetical order all my customers. Then when I run
this code it will search by customer, and find "their" worksheet, and
enter the data under the last row. Is this possible??


--
mount_mordor
------------------------------------------------------------------------
mount_mordor's Profile: http://www.excelforum.com/member.php...o&userid=26879
View this thread: http://www.excelforum.com/showthread...hreadid=401134