I have to identify if any of the columns have Xs in a given range and if so add an x to that range header.
Here is the example data:
This is what I need the output to look like: For example B3 and D3 have Xs in them because B4-B5 and D4-D5 both already have an X in them.
I have multiple worksheets where this "range" changes. For some B4-B5 is the Basketball Range whereas in another worksheet the range may be B4-B7. I was trying to come up with a macro that can add in the Xs regardless of the data range. I am an intern who has many workbooks of data like this to sort and having a macro would help a lot.
Thank you so much!
Here is the example data:
Book1345.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Description | 1 | 2 | 3 | ||
2 | ||||||
3 | Basketball | |||||
4 | AAA | X | ||||
5 | BBB | X | ||||
6 | Soccer | |||||
7 | CCCC | X | ||||
8 | DDDD | |||||
9 | EEEE | X | X | |||
10 | Tennis | |||||
11 | FFF | X | ||||
12 | GGG | X | ||||
Sheet6 |
This is what I need the output to look like: For example B3 and D3 have Xs in them because B4-B5 and D4-D5 both already have an X in them.
Book1345.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Description | 1 | 2 | 3 | ||
2 | ||||||
3 | Basketball | X | X | |||
4 | AAA | X | ||||
5 | BBB | X | ||||
6 | Soccer | X | X | X | ||
7 | CCCC | X | ||||
8 | DDDD | |||||
9 | EEEE | X | X | |||
10 | Tennis | X | ||||
11 | FFF | X | ||||
12 | GGG | X | ||||
Sheet7 |
I have multiple worksheets where this "range" changes. For some B4-B5 is the Basketball Range whereas in another worksheet the range may be B4-B7. I was trying to come up with a macro that can add in the Xs regardless of the data range. I am an intern who has many workbooks of data like this to sort and having a macro would help a lot.
Thank you so much!