Hi.

I have 10 large workbooks of about a million rows each. Each of these workbooks have a column R which has a value of 1 to 83. I need to be able to separate each row depending on what value appears in column R in the given row.

Is this possible?

EDIT:

Up until this point I have just been using the filter and copy and pasting but manually doing this will take far to long. I would need to do the same over 830 times and at the point the human error element concerns me as much as the time I would spend on it.