Ron de Bruin;116926 Wrote:
Hi Romeo

See
'Copy records with the same value in a column to a new sheet or
workbook' (http://www.rondebruin.nl/copy5.htm)

If you use Excel 2007 see also
'Table Tools in Excel 2007' (http://www.rondebruin.nl/table.htm)

--

Regards Ron de Bruin
'Ron's Excel Tips' (http://www.rondebruin.nl/tips.htm)


"Romeo" wrote in message
...
I have a number of different rows that relate to different customers
and i
wandered if anyone knew if i can split the data into new worksheets
every
time there is a change in customer name down the column

And, by all means, put Ron's site in your favourites ...


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=32559