Related Posts
Any Bain 🐠 willing to refer me in?
How is the wlb in legato
Additional Posts in Excel Genius
Time to convert to xlookup
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
I don't know how to write macros so it may be done better. I would do an if statement with a concatenate fx inside
=if(A1<>"", concatenate (A1,A12),"") (assuming A1 is the comments column
Yes you can
Very easy to code in macro, but as original commentator mentioned this is probably best done through a formula such as concatenaste
To clarify, the column itself doesn’t hold comments. Rather, the column has numbers and someone may have inserted a comment on a particular cell
Yes. You call up the comments property using, for example, Worksheet(1).Comments