+ Reply to Thread
Results 1 to 6 of 6

Create copies of existing sheet as per cell values

  1. 05-13-2013, 02:18 AM #1
    alf40 is offline
    Registered User
    Join Date
    04-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    33

    Create copies of existing sheet as per cell values

    Attachment 235223Hi all

    I have attached a spread sheet to help out.

    The macro I currently have enabled uses a date input and creates blank worksheets based on those values.

    I would like to keep this but instead of creating blank worksheets I would like it to copy the 'lead sheet' sheet and rename it.

    Any help would be appreciated.

    Thanks!
    Attached Files Attached Files
    Last edited by alf40; 05-13-2013 at 02:28 AM.
    Reply With QuoteRegister To Reply
  2. 05-13-2013, 02:49 AM #2
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Create copies of existing sheet as per cell values

    Replace this line ( In Two Places)
    Please Login or Register  to view this content.
    With

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 05-13-2013, 03:11 AM #3
    alf40 is offline
    Registered User
    Join Date
    04-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Create copies of existing sheet as per cell values

    Legend, Thanks!
    Reply With QuoteRegister To Reply
  4. 05-13-2013, 03:22 AM #4
    watersev is offline
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Create copies of existing sheet as per cell values

    option of the full code:

    Please Login or Register  to view this content.
    Last edited by watersev; 05-13-2013 at 03:33 AM.
    Reply With QuoteRegister To Reply
  5. 05-13-2013, 03:34 AM #5
    alf40 is offline
    Registered User
    Join Date
    04-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Create copies of existing sheet as per cell values

    Wow thanks a lot!

    What if I want to hide the lead sheet?
    Reply With QuoteRegister To Reply
  6. 05-13-2013, 04:04 AM #6
    watersev is offline
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Create copies of existing sheet as per cell values

    please check attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1