twmills
10-19-2022, 08:07 AM
Hello,
I'm trying to plug in a vba code that will make a cell active based on cross referencing headings in both the column and row. Since the location of the headings may change in it's row or column, I can't use an absolute cell reference like (K67), or any Offset codes to find the location based on the heading.
For instance:
In column A the code will be looking for a heading called 12b-1 Exp, and in Row 4 it'll look for the month of August 2022. So If "12b-1 Exp" happens to be in A67, and "August 2022" appears in K4, then I need the macro to make cell (K67) active (which provides an amount I need to extract).
Attached is an example of the file I'm working with.
30258
Hope this makes sense.
Thanks so much
I'm trying to plug in a vba code that will make a cell active based on cross referencing headings in both the column and row. Since the location of the headings may change in it's row or column, I can't use an absolute cell reference like (K67), or any Offset codes to find the location based on the heading.
For instance:
In column A the code will be looking for a heading called 12b-1 Exp, and in Row 4 it'll look for the month of August 2022. So If "12b-1 Exp" happens to be in A67, and "August 2022" appears in K4, then I need the macro to make cell (K67) active (which provides an amount I need to extract).
Attached is an example of the file I'm working with.
30258
Hope this makes sense.
Thanks so much