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

Since I'm seeing "new worksheets" and "change in customer name" (which I take
to mean a new customer name, I'm going to say that this can be done but that
it would have to be done with VBA code (a macro). I just did this very type
of thing for someone else here in these forums and what we did was to assign
a macro to a button that, when clicked, would either transfer the contents of
a particular row to a designated sheet (sheets were named with people's
names), or if it was a new person, then a new sheet was created and the
information transferred to it.

There are no worksheet functions to create new sheets in a workbook, so that
side of it alone requires VBA code to accomplish automatically.

"Romeo" wrote:

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

Hi Romeo

See
http://www.rondebruin.nl/copy5.htm

If you use Excel 2007 see also
http://www.rondebruin.nl/table.htm

--

Regards Ron de Bruin
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

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