Hi All -
Struggling new VBA-er here!
I have a sorted table that contains 8 columns of data. I want to have vba define a range (A-H) based on the eighth column which could either have a number (all sorted to the top) or a space (sorted at the bottom). I want to go on and make a pivot table of just the range/lines that have numbers in the cells.
Columns
A B C D E F G H
data data data data data data data number or space
data data data data data data data number or space
data data data data data data data number or space
data data data data data data data number or space
Thanks!
Amy
Struggling new VBA-er here!
I have a sorted table that contains 8 columns of data. I want to have vba define a range (A-H) based on the eighth column which could either have a number (all sorted to the top) or a space (sorted at the bottom). I want to go on and make a pivot table of just the range/lines that have numbers in the cells.
Columns
A B C D E F G H
data data data data data data data number or space
data data data data data data data number or space
data data data data data data data number or space
data data data data data data data number or space
Thanks!
Amy