+ Reply to Thread
Results 1 to 3 of 3

Macro to Copy Master Worksheet create and paste in new auto named worksheet

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Macro to Copy Master Worksheet create and paste in new auto named worksheet

    Hello,
    I am trying to create a macro button that will copy my master worksheet, create a new worksheet named with the current month, day, and year (example: Jan_5_2014). I need it to then paste special formatting and values from the master worksheet into the new month sheet and clear the master worksheet data while leaving the master worksheet locked and it's formulas intact. I also need the macro to stop with an error box if someone tries adding two worksheets with the same date name.

    Help please.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to Copy Master Worksheet create and paste in new auto named worksheet

    Hi, TheRealLethality,

    recording the action while recording a macro may give you the basic idea of what actions to take although the macro needs some work thereafter as the date yould be hard-coded.

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    05-02-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Macro to Copy Master Worksheet create and paste in new auto named worksheet

    Thank you Holger,
    I was recording a macro and trying to insert a new hard-coded date but couldn't figure out how to get it to use both subs.

    Please Login or Register  to view this content.

    With your solution though I can get it to work from here. Thanks again.

    Best Regards,
    Lethality

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] copy the particular worksheet from closed wb,paste as individual worksheet into master vba
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2014, 10:25 AM
  2. [SOLVED] Need help! Macro to open sequentially named files, copy and paste data into a master file
    By derrickk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-05-2013, 03:35 PM
  3. Copy a row from master sheet and paste it to a specific worksheet based on tab name
    By obrie499 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 10:45 AM
  4. Create Macro to copy and paste data from one worksheet to another and enter page breaks
    By haleakala17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:23 PM
  5. create a copy of a master worksheet from a table new entry
    By nikenis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2012, 04:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1