VBA to Concatenate rows based on another cells value
Hi,
I have a table of data from a system I use. some rows contain jobs and rows directly below each job contain the separate tasks that need to be completed (including the name of the person delegated for that task)
I’m trying to use VBA to modify the table to show the Job and a cell with the delegates, separated by a comma or line break.
e.g.
Job1Title1Due Date Job1Task1 JohnJob1Task2 JohnJob1Task3 MikeJob2Title2Due Date Job2Task1 BradJob2task2 MikeJob3Title 3Due Date
converted to
Job1Title1Due Date
John
John
Job2Title2Due Date
Brad
Mike
job3Title3Due Date
The actual table has over 200 jobs and most have several tasks each, and I have other VBA elements that modifies other columns. I can do the basic VBA for the rest of the table, but this has me stumped.
Can anyone point me in the right direction please.
Leon.
Hi, I have a table of data from a system I use. some rows contain jobs and rows directly below each job contain the separate tasks that need to be completed (including the name of the person delegated for that task)I’m trying to use VBA to modify the table to show the Job and a cell with the delegates, separated by a comma or line break.e.g.Job1Title1Due Date Job1Task1 JohnJob1Task2 JohnJob1Task3 MikeJob2Title2Due Date Job2Task1 BradJob2task2 MikeJob3Title 3Due Date converted toJob1Title1Due DateJohnJohnJob2Title2Due DateBradMikejob3Title3Due Date The actual table has over 200 jobs and most have several tasks each, and I have other VBA elements that modifies other columns. I can do the basic VBA for the rest of the table, but this has me stumped. Can anyone point me in the right direction please.Leon. Read More