Every week a file is downloaded from a database and the column headings are sometimes in different columns.My macros are setup to filter out all 0.00 for column "M" every week but sometimes, the information is in column "N", however the column heading is always the same "90_Day_AR".I have it setup now to select "Columns("M:M").Select" and filter.Can someone give me verbage to find or match "90_Day_AR" and use that information to select the column the header is in, so i can filter and sort that column?I used the match function to find the number but don't konw how to use the number to tell excel what column the information is in. Any Suggestions?1 person needs an answerI do too

Every week a file is downloaded from a database and the column headings are sometimes in different columns.My macros are setup to filter out all 0.00 for column "M" every week but sometimes, the information is in column "N", however the column heading is always the same "90_Day_AR".I have it setup now to select "Columns("M:M").Select" and filter.Can someone give me verbage to find or match "90_Day_AR" and use that information to select the column the header is in, so i can filter and sort that column?I used the match function to find the number but don't konw how to use the number to tell excel what column the information is in. Any Suggestions?Not likely in this forum. If you are using a Microsoft Office program, try asking in those forums (Access forum ) (Excel forums -- pick one )