How do I automatically select an "auto filtered" range???
Posted by Roger on March 20, 2001 11:01 PM
I am using the auto filter function to select groups of data. I then have to copy and past that data somewhere else. I would like Excel to automatically select this filtered data. Is there a way to do this? The number of columns is fixed but the number of rows varies. I can't seem to figure out how to automate this part of my spread sheet. I am still new at Excel. Maybe even better yet... can I perform functions on this data? Such as Sum(... or Average(...
The problem is once the rows are selected I may see rows 23,24,45,46,47,78,88 etc. Using Sum(... will summaize 23:88 inclusive. Thanks a million for any help.