xxxxxxxxxx

  1. B

    Copy from one source file into multiple excel files - All live in one location

    Hello , I have an excel file which is the source document and I have other excel files which are destination files all in one location. - I want VBA to open the source excel and Format the Date in Column C of the source to MM YYYY. - Check if column A has the word 'SIGNAPAY' , - If true then...
  2. C

    Importing email bodies from specific sub folder in Outlook

    Good Evening everyone! I'm trying to configure a VBA Macro in excel that will import the body of emails into separate lines. Mostly concerned with getting the link between Outlook & Excel working. I have some novice experience with VBA, but this is proving much trickier than I anticipated...
  3. A

    Auto Journal Entry Creation based on the bank statement download

    Below is the Raw bank statement <tbody> Book Date Transaction Type Settled Amount Bank Reference All Transaction Details 4/9/2018 I/W RTGS PAYMTS 100 aaaaaaaaa asasdsasadasdsadasdasddsadasdasds 4/10/2018 NEFT INWARD 200 aaaaaaaaa asasdsasadasdsadasdasddsadasdasds 4/10/2018 TDS ON DEP...
  4. G

    Using Right and Substitute together in a formula

    For some reason I can't get this to work. Any help is appreciated AccountSSName1 = John Smith DOD [1234-1234] Out of that string I want to: #1 - replace "[" & "]" with "(" & ")" so I can later name a tab of the worksheet with this value #2 - just keep the 1234-1234 Keep in mind the value in...

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