lkirke
asked on
Macro to merge cells across columns based upon criteria
Hello experts,
I would like to have a macro that merges three columns based upon a set of criteria.
For instance, I have four columns of data, and for all rows with data in column A, if column D has data, but where also column B and C are blank, then merge column A with column B and column C.
Please find attached an example as a illustration.
Could anyone provide some assistance?
Regards
LK
EE-Example-Merge-Columns.xlsm
I would like to have a macro that merges three columns based upon a set of criteria.
For instance, I have four columns of data, and for all rows with data in column A, if column D has data, but where also column B and C are blank, then merge column A with column B and column C.
Please find attached an example as a illustration.
Could anyone provide some assistance?
Regards
LK
EE-Example-Merge-Columns.xlsm
ASKER
Hi Rgonzo,
Works great apart from the warning message for each merge. Is there a way to turn these off?
Works great apart from the warning message for each merge. Is there a way to turn these off?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fantastic. Thank you.
pls try
Open in new window
Regards