PDA

View Full Version : Copy AutoFilter Results



inajica
01-14-2008, 03:00 PM
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
01-15-2008, 07:58 PM
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.