Hi All
I need to format a sheet where the number of columns is not fixed. Sometimes the column name "Charged Date" is found in Column X or sometimes in Column Y etc. Basically I’d like to:
• Find the column header “Charge Date”
• Apply Autofilter to all columns
• Sort from Oldest to Newest (Charge Date)
I already use an array to id the the column headers and reorder the columns (see below) that I found on the forum.
There must be a way to use the same array to get the result I’m looking for or maybe there’s a faster way………Please Login or Register to view this content.
Attached is a sample of the actual sheet.
Bookmarks