Hi ,

I have a workbook where I enter the data for drivers including
postcodes, names etc, I have a new worksheet for each day and for each
driver.I have to have seperate sheets for the drivers each day as we
then print these off and use them for pick sheets for the warehouse and
drivers sheets for the drivers.

How can I set up another worksheet where everytime I enter a postcode
it copies this in the sepaerate worksheet, so that I then have a list
of all the postcodes where we have delivered. I can then import these
postcodes into Autoroute, and I can then see where drivers are
delivering to more than others etc..

I hope that someone can help

thanx


--
thebig_a
------------------------------------------------------------------------
thebig_a's Profile: http://www.excelforum.com/member.php...o&userid=27432
View this thread: http://www.excelforum.com/showthread...hreadid=470431