Hi,

I don't even know the best way to approach this so any help i
appreciated.

I have a workbook which is filled automatically to create an unknow
quantity of worksheets (It varies each time). Some rows of thes
worksheets need to then be copied to a number of different workbook
depending on what they contain. E.g There are 4 types of equipmen
parts which would fill 4 different order sheets (1 for each type o
equipment). This will be done by having an option button at the end o
the rows, which will be selected to show which rows need to be copied
The cells to be copied can vary and when they are copied they need t
create a list with no blank cells going down a row each time.

I guess I need some way to find the next blank row or something lik
that.

As I say, even designing this is a bit confusing.

Any ideas?

Thank

--
Susie
-----------------------------------------------------------------------
SusieQ's Profile: http://www.excelforum.com/member.php...fo&userid=3081
View this thread: http://www.excelforum.com/showthread.php?threadid=51366