+ Reply to Thread
Results 1 to 1 of 1

macro to copy a range of worksheets based on cell entry and rename specific sheets

  1. #1
    Registered User
    Join Date
    12-12-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2010
    Posts
    40

    macro to copy a range of worksheets based on cell entry and rename specific sheets

    I have a Excel 2010 workbook with a range of worksheets named Tracking, CO 001 Start, CO-Simple, CO-Breakdown, CO-Worksheet & CO 001 End. The tracking worksheet contains a table where cells A5:A20 are user entries. What I would like is when a user enters a new entry in one of these cells (A5:A20) that the range of worksheets CO 001 Start, CO-Simple, CO-Breakdown, CO-Worksheet & CO 001 End is copied and placed at the end of the worksheet tabs.
    If it's also possible to have the CO start and CO end sheets renamed to the user entry (i.e. CO 8123-002 Start) that would be very helpful.

    Is it also possible to clear specific cells only when the new sheets are copied?

    I've attached the workbook as well for reference.

    Thanks in advance for helping out.
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1