microsoft 2016

  1. U

    VBA: Combine data from Multiple Workbooks Into One File and Consolidate into one Tab

    Hello Gurus, Good day! Could you possibly help me tweak below code? I have multiple workbooks and need to combine into one. I have below code that can do it. However, I am getting an error message whenever there is same tab name that exists on different workbook. Note that the tab name most...
  2. U

    Merge Multiple Sheets

    Hi Guys, Happy New year! I found below code however, it seems like only column A of each sheet is being copied on the combined Sheet. Is it possible to adjust the range and copy everything except Row 1 for each sheet? = = = = = Sub Combine_Sheets() Dim startRow, startCol, LastRow...
  3. U

    VBA Excel Format (Based on Date and Criteria)

    Hello Gurus, Trust you are doing well at this times. I just wanted to get your thoughts on how to code this. I have a workbook with two sheets: Sheet 1 Date Account Reference 12/30/2018 5000 0001 11/30/2018 4000 0001 10/30/2018 3000 0003 09/30/2018 4000 0002 08/30/2018 3000...
  4. U

    VBA Powerpoint to Excel

    Hello Excel Gurus, I'm trying to link my excel tabs sheets to a powerpoint template. However, whenever I run the macro, the charts overlaps in the slides. Is there any way where I can set the slide view to 100%? Whenever I open the PPT, its always set to 115% - not pretty sure if this is the...
  5. U

    Exporting Excel Charts to PowerPoint

    Hello Gurus, Good day! Could you possibly help me amend the codes I found below: Basically, I am trying to create a PPT Template for my report - the charts, table format and tab names in excel are same. Is there any way to copy the format in excel (as seen in the excel print preview) on the...

Watch MrExcel Video

This Week's Hot Topics

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
Top