Hello,
I am just beginning to learn Excel macros. I was working on a sheet wherein I have to select a column dynamically, based on just the column header name. Let me explain.
Say there is an Excel Sheet which contains the following columns (from A1 to D1):
RecNo Cust_ID Cust_Name Contact_Num
Below these, there is customer data which is present. Now, I want to extract just the Cust_ID (from Column B) and Cust_Name (from Column C) for all the records.
However, the problem is that it is not necessary that Cust_ID would always be in Column B. Though the heading would always be Cust_ID, its location could change to Column C in some other sheet that has been generated and Cust_Name could instead have been present in Column B (the two columns that need to be extracted have been interchanged).
Using the match function, I am able to determine the position of the column, but after that I am not able to select that column. The function I have used to determine the column number is given below:
WorksheetFunction.Match("Cust_ID", Range("A1:D1"), 0)
Can someone please help?
Configuration: Windows XP Internet Explorer 7.0
Creating an excel macro to separate by a column Excel macro select specific column Excel macro add column to chart range Excel macro adding columns Excel macro combine worksheets with different column Excel macro copy selected rows Excel macro copy selected rows sub searchstring Excel macro delete cell based on a value Excel macro duplicate columns Excel macro how to select excel workbook on new path Excel macro if else Excel macro multi select Excel macro sort range . select Excel macro to copy columns from multiple sheets in one workbook to another Excel macro to copy select data down one cell Excel match two columns How do you get an excel macro to refer to different columns every time you run the macro? Multiple lines to column excel macro