Results 1 to 3 of 3

Create a new sheet based on a Cells value

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    52

    Create a new sheet based on a Cells value

    Hey all,
    I have a main sheet with personnel and some data. Each person should get a separate sheet name ex: "Kent, Clark" on main sheet should have a sheet named "Kent-Log" in the same workbook.
    I have a template setup already for Kent. What I am looking to do is when I enter a new persons name(Last, First) on the main sheet, i want VBA to copy "Kent-Log" and rename to "Last-Log". I have several people to add and am trying to avoid -copy ->move to end--> rename

    Any help is greatly appreciated.
    Last edited by usafmeinweg; 04-05-2010 at 09:44 AM.

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