Results 1 to 4 of 4

Automatically create a copy of Master sheet when data entered into specific rows

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2014
    Location
    Perth, Australia
    MS-Off Ver
    2019
    Posts
    31

    Automatically create a copy of Master sheet when data entered into specific rows

    Hello all,

    I am wondering if it is possible to automatically create a copy of the "Master Do Not Delete" sheet when data is entered in rows A4-80 on "Staff" sheet? The newly created sheet should be automatically named the same as the data entered into the previous mentioned rows. And I think it would be good for "Master Do Not Delete" to be a hidden sheet so no one can delete it accidentally.

    So to give an example of what I'm thinking:

    "Mike" is entered into Staff!A4. When this is entered, Excel automatically copies Master Do Not Delete! and renames it "Mike" and places this newly created sheet at the end of all sheets.

    I hope this makes sense.
    Attached Files Attached Files
    Last edited by itsawayoflife; 09-21-2018 at 12:10 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 19
    Last Post: 10-16-2017, 12:34 PM
  2. Automatically add multiple new rows when data is entered into the sheet.
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2014, 12:22 AM
  3. Replies: 1
    Last Post: 02-26-2014, 08:54 PM
  4. [SOLVED] Copy Data from one sheet to another when a specific value is entered
    By kittu55 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 12:45 PM
  5. [SOLVED] Automatically copy data from one worksheet to another based on a specific word entered
    By arkadd61 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 08:23 PM
  6. Automatically add rows and copy formulas when data entered
    By alina_t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2011, 02:30 PM
  7. Excel 2007 : Automatically Copy Data from Master Sheet
    By andy9988 in forum Excel General
    Replies: 7
    Last Post: 10-13-2010, 01:04 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