copy and rename sheet

  1. D

    Vba Copy sheet, rename from cell value and Add Hyperlink to that sheet

    Hi All I need some help please, I need to be able off a button press (i can create the Button etc.) Add a New work sheet Report (copy of a pre-existing Report) Have code for this below. Re-Name that sheet depending on the name in the current active cell Hyperlink link the new report off the...
    • Dave8899
    • Thread
    • copy and rename sheet hyperlink & sheetname rename sheet
    • Replies: 1
    • Forum: Excel Questions
  2. J

    VBA - Copying rows in between ranges

    Good Afternoon, I've been working on a file that has been automated in the past with simple formulas or just by linking cells to other sheets. In this case, I'm having trouble programming a macro, by using a button, to copy a specific table in between ranges. The ideia is to click the button...
    • jo_hivera
    • Thread
    • copy & past rows vba copy and rename sheet copy sheet macro vba
    • Replies: 1
    • Forum: Excel Questions
  3. P

    Need a VBA macro to copy a hidden tab and rename it based on the cells in a different sheet.

    Hi All, I am new to Mr. Excel and VBA codes so please bare with me. Essentially, I need a code for a button that will copy a hidden tab, duplicate itself a number of times, then and rename the copied tabs based on the cell names in a different sheet. So for Sheet1 I have the button and a list...
  4. J

    Copy and create new name if sheet exist then + 1

    Ok i have spent nearly 2 hours looking through posts and trying to piece together what I need. I would be extremely appreciative if someone can help me with my code which doesn't work. I want it to copy the sheet "template" and create a copy named 1, if one exists then rename 2, if 2 exists then...

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