#excel #vba

  1. F

    Compare rows from 2 different sheet and paste unmatched rows into another sheet

    I want to match rows from two different sheets and put the unmatched rows into another Sheet3. The code should compare the rows of the two Sheets and copy the outstanding rows into a newly created sheet. Sheet2 (say Jan 2020) contains more rows than Sheet1 (Dec 2019) as its the recently updated...
  2. J

    Merge Excel Files Saved in SharePoint

    Hi, I have a macro in my local drive which allows me to merge multiple workbooks saved in a specific folder into one workbook. I need these files to be stored in SharePoint instead of local drive but when I try to change the path to a destination in SharePoint, the macro returns an error for...
  3. J

    Putting a text only if nothing follows to a specific word using VBA Excel

    https://ibb.co/gqQ2Ow Please see my captured result of the code I came up, I want the results to be just the second encircled one. I don't need to add epoxy if there is already a word after trimform which is like the first encirled one. Pls help me. TIA! :smile...
  4. R

    VBA to convert the text to upper case based on condition

    Hi everyone, I need a macro to change the text before .(dot) to upper case. Below are the sample data to be considered, In the below table, In column A, We have the name Starvin.VINAYKUMAR, which should be STARVIN.KUMAR. dEEpak.rajkumar_345 should be DEEPAK.rajkumar_345 Rafeil_nadal.a_324...
  5. W

    Excel Mail Merge with Outlook

    Hi, Is it possible to create a form on excel to have it mail merge with outlook and be sent out to clients ? I.E. I want to create a document in excel where you can answer questions and those questions get answered for us and put nicely back into excel. If anyone know how this would be setup...
  6. P

    Create outlook appointments using excel 2010

    Hi, I want to create outlook appointments in outlook 2010. Below is the code which creates appointments. Few issues which I need to fix --> How do I invite attendees, if any? Below code creates duplicates :( For instance if the appointment is altered, how do I ask the macro to update the...
  7. L

    Insert Filename Footers Into Numerous Workbooks

    I'm very new to the world of VBA, but I need a VBA script to insert the filename as a footer into Excel. Ideally, I would like to insert the first 7 characters of the filename into the footer of each tab in an excel files.I have about 5000 Excel files that need this macro. The loop through...
  8. P

    send email when specific file in a folder is updated

    Send email when specific file in a folder is updated. Anyone has the code? Thanks

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