Dear All
Would like some help on putting together some code please.
How can I join a set of values in cells in a column into 1 long string in a cell?
For example, my problem is - starting at H3 (H2 being a heading) I have a list of outstanding invoices (i.e. H3 = 70k H4 = 228k etc down to H?) and I would like to join these together separated by a comma into 1 string say in H1 (i.e. 70k, 228k, etc, etc, etc) to put into a report.
I have very basic knowledge of using arrays and examples I have found do not do what I need.
Thanks as ever.
Julian
Would like some help on putting together some code please.
How can I join a set of values in cells in a column into 1 long string in a cell?
For example, my problem is - starting at H3 (H2 being a heading) I have a list of outstanding invoices (i.e. H3 = 70k H4 = 228k etc down to H?) and I would like to join these together separated by a comma into 1 string say in H1 (i.e. 70k, 228k, etc, etc, etc) to put into a report.
I have very basic knowledge of using arrays and examples I have found do not do what I need.
Thanks as ever.
Julian