A spreadsheet I created was improved greatly with the help of this forum. I only use this spreadsheet once a year for tax purposes and each year I try to improve it.
Two CSV files are imported into separate sheets within one spreadsheet. The data is filtered and summarized on different sheets.
The issue, each year some columns are moved to different column letters. Thus, my macro pulls in different data then the macro must be updated to pull in the correct data. This is not a big deal but one CSV file has over 300 columns so I must search for the correct column letter then update the macro.
What I want to do, add to my Summary page a list showing current column letters for required data columns plus show the column letter for the new imported CSV file. This way, a quick glance and I can determine if the macro requires an update and also instantly see the new column letters without checking over 300 columns.
For Example…
Current New CSV Import
Order_date Column A: Column B:
Order_invoice Column D: Column E:
Order_amount Column: IZ: Column KD:
I found several methods including some on this forum but either the method did not work for me or was way above my pay grade. I only need a simple method / formula. One formula…. =MATCH("order_date",Data!A1:KM1,0) brings in the column number but I can't figure out how to convert the column number to the Column letter. I realize I can use column numbers in my macro but I'm use to using column letters and prefer to keep it that way.
Any suggestions to convert a column number to column letter or a totally different method?
Thank you