Combine cell data based on adjacent cells?
Is there a formula or VBA that can achieve this?
It's OK to have helper columns if needed.
Social distance - Don't touch your face - Wash your hands for 20 seconds
I've been trying (without success) to find a VBA code that would do following:
If AB is NOT blank, concatenate values from AD until blank row reached
Social distance - Don't touch your face - Wash your hands for 20 seconds
See attached sample, if it's easier to achieve this with blank rows, that would work too....which ever version of the file works for you.
Thanks!
Book1.xlsx
Thanks for this...It's huge help!
Only thing I noticed that needs a tweak is the last row with info...it adds a bunch of semi-colons ;;;;;;;;;;
Any way to correct that?
Just tested it...works great!
Thanks again!
Sasha
Social distance - Don't touch your face - Wash your hands for 20 seconds
29126114a.xlsm
Social distance - Don't touch your face - Wash your hands for 20 seconds
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions