Hi Andy

Why not make life easier for yourself by entering all the data for all
drivers and dates on the same sheet.

You could select any date, or any driver at time using Autofilter.

Assuming row 1 contains your column Headings, mark the range of cells in row
1, then DataFilterAutofilter


Regards

Roger Govier


thebig_a wrote:
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.

How can I set up another worksheet where everytime I enter a postcode
it collects this in the sepaerate worksheet, so that I then have a list
of all the postcodes where we have delivered.

I hope that someone can help

thanx

andy