Split match array results into new worksheets

Hi there,

I've done some research and pulled together some code from other threads but a bit stuck now...

I'm trying to split some data based on two columns with criteria which one has a user input box. Then with the output array I need to split the results into new worksheets/workbooks based upon row count from another input box. New workbooks to be saved with sequential number order.

Kind regards

Please Login or Register  to view this content.

I am assuming the values in column C are numeric, not text. Your pseudo code above would not work for actual NUMERIC tests, only for text comparisons. If you search for 1 in a cell with a value 15, it will match using INSTR. So I did not use that.

If the column C values are actually text strings, we'll need to discuss exactly what those strings look like for all the 1-17 examples to be sure we get an accurate test.

Meanwhile, using straight numeric testing in column C, this seems to work.

Please Login or Register  to view this content.

That shouldn't be happening with my code above. I spoke of this and your original use of "INSTR()" method, I did not use that for Column C, I used an exact VALUE match. 10-17 are not matches to 1 so that shouldn't happen. I'd need to see what you're seeing.

On the off chance I uploaded the wrong last version, here it is again.