birmingham

  1. D

    Macro to merge cells

    Hi I a trying to create a macro that will merge a number of cells in a column based on a value in another cell the spreadsheet is laid out Column A Column B Column C Column D Column E City ProductID Cost Total Amount Count London 001...
  2. K

    Most Occurring Text Multiple Criteria

    Hoping there is someone out there, with a genius mind in VBA or excel formulas. I data set: <tbody> Name Location Outcome Kris Barbados W John Glasgow L Kris Birmingham W John Barbados L Kris Birmingham W Kris London L Kris London W Kris London L John London W </tbody> I...
  3. R

    VBA to remove characters from a comma separated list, where certain characters are found?

    Hi all, need fast help on this as I'm under a timescale. I have a list of ads due to be placed in a paper and under the "Pickups" for coach travel there is meant to be a list of coach-only pickups, but air and rail have slipped in. As an example, please see the below: Bury St Edmunds...
  4. S

    Split worksheet into tabs then email

    Hi everybody, I hope someone can help with a code for this please? In the example below, I would like to split a worksheet at each change in the Location column so that the data goes into a new sheet of the same workbook, then email each new tab to the relevant email in cell E2 using Outlook...

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