Copying and Concatenating data in excel based on a value in another column

p45cal · #1 10-17-2021, 05:06 AM

You can try a function like this:

Code:

Function ConcatRows(sce, WhichRows)
For Each rw In WhichRows
  Z = Z & sce.Cells(rw).Value
Next rw
ConcatRows = Z
End Function

and use it in a worksheet thus:
=ConcatRows(A1:A15,D1:D4)
or:

=ConcatRows(A1:A15,{2,4,6,8})

No checks or bells and whistles.

BoardingSUP · #2 10-17-2021, 06:25 AM

That worked great, Thank you for the help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel)	wvlls	Word VBA	1	03-22-2019 02:29 PM
Copying data in a column to another column	Peace Freak	Excel	2	04-28-2017 12:31 AM
Extract data based on pattern with respect to specific column	PRA007	Excel Programming	14	12-04-2015 04:32 AM
Help with Macro - copying formula to last line of data based on another column	kidwispa	Excel Programming	1	07-12-2015 05:01 PM
Copying data from Project to Excel	OTPM	Project	13	12-20-2013 10:25 AM