@fluff

  1. M

    Copy the Workbook from userform i.e, load the workbook path and copy the output workbook path

    Hello All Hopefully one of you awesome excel experts can help... I have to create a userform with Commandbutton to navigate on (Get workbook path) selecting the "Abc" excel workbook, it should copy with all the sheets that are available in "Abc" workbook and paste that in different path as...
  2. S

    Macro to Merge the works with sheets

    Hello Team, Need a Macro where i have workbooks with 5 sheets. with sheets having different column headeres. Similary i have the workbooks with 5 users. currently i have to merge all the 5 workbooks with 5 sheets.
  3. M

    How to Sort Excel Sheets from Multiple Excel files in one folder

    Hi All, I have multiple excel workbook ( 85) in one folder. Each workbook contain 13 sheets has same names with different order. Only Excel workbook name is different. Now I want to assign all workbook sheets in one order. Kindly note Its not assent or dissenting order. I had listed all...
  4. W

    Excluding Worksheets from a Workbook Copy pt 2

    Fluff you provided code to copy the contents of worksheets beyond the Summary worksheet. This works phenomenally however it is bringing in a formula and I was curious if I could just get it to copy the values. The other thread has the same title w/o pt 2

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    • Started by Tayl4n
    • Replies: 31
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    • Started by EBoudreau
    • Replies: 27
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    • Started by rebel123
    • Replies: 26
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    • Started by aadil_1408
    • Replies: 24
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    • Started by dpaton05
    • Replies: 22
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

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