Copy AutoFilter Results

[inajica]

I have six columns of data of numbers and letters. I will do a Custom Autofilter column E1 (which is just number data from 1 to 175) starting at 1 and copy all the six columns of visible data to sheet 2. I would continue that in increment of one until I get to the end of my numbers. Thank you for any help with this

[herzberg]

Let me see if I get you correctly on this. Column E contains numbers ranging from 1 to 175, right? In that case, you can do a simple sort to rearrange the data in ascending order.