Okay, I always get confused on this:
My headers exist in Row 12.
An autofilter is applied.
There's a column with the header "YTD Expense\Avg FTE", which constantly moves around as columns are added and removed from the sheet (but it should always be on row 12). I'll call that my Target column.
There MAY or MAY NOT be data under the pertinent data in my target column (if so, it will be separated by at least two blank lines).
I want to copy the visible cells in my target column, under (not including) the header, to the bottom of the filtered data, above any data that may be under it.
Any takers on how to do this? I can do all the copying, I just don't know how to zero in on my desired target column and my desired data within it.
Any help is greatly appreciated.
Bookmarks