J
jacqui
I would like to assign numeric values to fields of an
extract file (imported to worksheet 1) based on an
underlying table. The table looks like this and is held
on a separate worksheet called "table".
Column A Column B
GWP 1
Earned 2
RI Result CY 6
RI Result PY 7
Claims CY 4
Claims PY 5
Expenses 3
Tax
Investments
Result 8
The fields in the extract file are output in the same
order as column A above so that GWP, Earned, RI Result CY,
RI Result PY, Claims CY etc. However in an empty row
beneath these fields I'd like to reflect the values shown
by Column B. This is so I can run mulitple reports from
the same extract and effectively resort the fields to
achieve a different layout for a different report type.
Note, I dont always use all the fields for the alternative
reports, ie ignore Tax and Investments.
What VBA syntax would I use to match the descriptions in
the table with those of my extract file and where a match
is found insert the corresponding value in the row beneath
the caption. Note the caption always appears in row1
across all columns.
Can anyone provide a brief example?
Many thanks
Jacqui
extract file (imported to worksheet 1) based on an
underlying table. The table looks like this and is held
on a separate worksheet called "table".
Column A Column B
GWP 1
Earned 2
RI Result CY 6
RI Result PY 7
Claims CY 4
Claims PY 5
Expenses 3
Tax
Investments
Result 8
The fields in the extract file are output in the same
order as column A above so that GWP, Earned, RI Result CY,
RI Result PY, Claims CY etc. However in an empty row
beneath these fields I'd like to reflect the values shown
by Column B. This is so I can run mulitple reports from
the same extract and effectively resort the fields to
achieve a different layout for a different report type.
Note, I dont always use all the fields for the alternative
reports, ie ignore Tax and Investments.
What VBA syntax would I use to match the descriptions in
the table with those of my extract file and where a match
is found insert the corresponding value in the row beneath
the caption. Note the caption always appears in row1
across all columns.
Can anyone provide a brief example?
Many thanks
Jacqui