troubleshooting Question

Generate Comma Separated string from columns based on condition in Excel using VBA

Avatar of nainil
nainilFlag for United States of America asked on
Microsoft ExcelVB ScriptProgramming
3 Comments1 Solution349 ViewsLast Modified:
I have three columns in Excel:

 
Sheet		Errors			Status
Codes		15 Errors found		Yes
Names		250 Errors found	No
Details		No Error		Yes
Sheet4		No			No

Open in new window


I want to generate a comma separated string from the first column where status='Yes'.

For eg, 'Codes, Details' should be generated
ASKER CERTIFIED SOLUTION
rspahitz

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros