GiacTorrence
New Member
- Joined
- Dec 2, 2014
- Messages
- 40
Thank you again.
Darko
Hi all,
I'm currently working with a fairly large data set (a sample of which is attached) that contains a drop-down list of options that respondents can choose from.
I've written some VBA that will place a certain race selection into a category in the cell next to it.
Right now I'm just having some issues modifying the code to apply similar logic to columns P and Q.
So:
Learning = N/A
ASDS = N/A
ADDH = N/A
LMAP = N/A
Other = Blank
Blank cell = Blank (until option is selected)
Learning, ASDS, ADDH, LMAP and Other are all in column P, and where I would like the N/As and Blanks to appear are in column Q.
(Attached an updated workbook for reference)
https://www.mediafire.com/file/i5r8e...ook2.xlsx/file
Any suggestions would be greatly appreciated, thank you!
Darko
Darko
Hi all,
I'm currently working with a fairly large data set (a sample of which is attached) that contains a drop-down list of options that respondents can choose from.
I've written some VBA that will place a certain race selection into a category in the cell next to it.
Right now I'm just having some issues modifying the code to apply similar logic to columns P and Q.
So:
Learning = N/A
ASDS = N/A
ADDH = N/A
LMAP = N/A
Other = Blank
Blank cell = Blank (until option is selected)
Learning, ASDS, ADDH, LMAP and Other are all in column P, and where I would like the N/As and Blanks to appear are in column Q.
(Attached an updated workbook for reference)
https://www.mediafire.com/file/i5r8e...ook2.xlsx/file
Any suggestions would be greatly appreciated, thank you!
Darko
