Current.png shows a simple example of my dataset. I want to count every value in column furniture and eventually get the dataset as shown in wanted-outcome.png. However, the code needs to look at the column name and not the column number. I want to use the vba for different sheets where column furniture may not always be in the same place.
I tried several things but neither came close. Any suggestions?
I tried several things but neither came close. Any suggestions?