Find a column by title even if its been moved and show contents on another sheet

do you mean actually copy, or just reference the values from it?

If you create a Dynamic Named Range for the column, you can always reference it by name...even if it moves.

Example:
• Select Col_E on a Sheet1
• Insert.Name.Define
...Names in Workbook: SourceColumn
...Refers to: =Sheet1!$E:$E
...Click: OK

Now, from anyplace in the workbook you can press F5 and choose SourceColumn...and it will select the SourceColumn range.
If you insert columns before Sheet1!$E:$E so that data now exists in Col_M, SourceColumn will refer to Sheet1!$M:$M.
You can also use the SourceColumn as a range reference in VBA.

Is that something you can work with?

Originally Posted by KAPearson

Thanks! I wouldn't have thought of that but I've already defines names so of course! Could you please give an example of how I can use it in VBA?

I believe something like this would work...

Please Login or Register  to view this content.

...or...this:

Please Login or Register  to view this content.

Does that help?

Assuming you want to autofilter on the "Dept" column, you need to determine which ordinal position in the filter data headings contains "Dept".
Try something like this...
With the headings in Row_1

Please Login or Register  to view this content.

Then use RowPos in your AutoFilter code.