merge adjac

  1. P

    Match and Merge data having same pattern with a delimiter

    Dear Helpers, I am looking for VBA Solution which is very peculiar situation and crack my head to do it as Simple but could not do that. I request this could be done by a Macro and seeking your kind Help. - Overview Sheet 1 contains Column A and Column B - Column A has unique values to be...
  2. Small Paul

    VBA Merge Adjacent Dynamic Cells

    Hi I suspect there is a simple answer to this but I cannot find it! I have a sheet with a variable number of rows. I have totals at the bottom of columns J & K. I then have a combined total in column J - offset(0,2). I need to merge the cell in J with the adjacent cell in K. I have tried...
  3. E

    how to merge cells containing same content

    Hi everyone, I have a dataset in which the top row gives me the days of the year and the cells below contain a formula giving me the name of a promo that covers a certain amount of days. The result is a dataset in which every row has a certain amount of contigous cells containing the same...
  4. S

    Merge cells in the same column if they have the same value

    Hi, good morning to all, I need to merge adjacent cells that are on the same column whenever they have the same value. I have tried the following code (as part of a longer code), but this function is not working, it does not break, but it does not make any changes neither...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top