podder
07-15-2022, 10:23 PM
Hi,
I am looking for a VBA solution to the following:
I have a number of headings:
Red Blue Green Yellow
I then have a list of two columns that abbreviates each one as follows:
Re Red
Bl Blue
Gr Green
Yl Yellow
When I get new data it comes in the form of 2 columns as shown below:
20 Yl
10 Re
12 Bl
8 Gr
15 Gr
15 Bl
6 Ye
14 Re
I currently have a spreadsheet setup, using formulas where the given values are distributed under their appropriate headings as shown below:
Red Blue Green Yellow
10 12 8 20
14 15 25 6
Is it possible to obtain the same outcome using VBA.
Thanks
I am looking for a VBA solution to the following:
I have a number of headings:
Red Blue Green Yellow
I then have a list of two columns that abbreviates each one as follows:
Re Red
Bl Blue
Gr Green
Yl Yellow
When I get new data it comes in the form of 2 columns as shown below:
20 Yl
10 Re
12 Bl
8 Gr
15 Gr
15 Bl
6 Ye
14 Re
I currently have a spreadsheet setup, using formulas where the given values are distributed under their appropriate headings as shown below:
Red Blue Green Yellow
10 12 8 20
14 15 25 6
Is it possible to obtain the same outcome using VBA.
Thanks