+ Reply to Thread
Results 1 to 2 of 2

How to add a name in mastersheet and auto creates new row in other sheets

  1. #1
    Registered User
    Join Date
    07-31-2015
    Location
    Scotland
    MS-Off Ver
    2013
    Posts
    1

    How to add a name in mastersheet and auto creates new row in other sheets

    Hi!!
    So, I am creating a holiday tracker for my new job and I am nearly finished barr one thing. In my master STAFF sheet I want to be able to add a new employee here and then that automatically create a whole formatted row in the other worksheets. So when Joe Bloggs is added the worksheets automatically create a row for him above my totals and is added into the formatting so that other members of staff when using the tracker only have to add the name and he is added everywhere else automatically.

    I hope that makes sense! Any and all help is greatly appreciated

    TIA - Nina Noir
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,440

    Re: How to add a name in mastersheet and auto creates new row in other sheets

    You can probably do it with VBA. And it might make things easier in some respects if you have your data in Structured Tables.

    Either way, it's doable but, if you split the data across multiple sheets, there will probably come a time when you need to analyse it all ... and it won't be easy.

    If you can, keep all the data relating to your staff in one sheet. Maybe group columns to make it more user friendly.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Mastersheet, auto input named rows onto other named sheets
    By Chalkie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2014, 12:33 PM
  2. VBA code for creating a auto generating mastersheet
    By alhoskins23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 01:22 PM
  3. Excel 2007 : Mastersheet Data OntoIndividual Sheets
    By STJES in forum Excel General
    Replies: 1
    Last Post: 11-01-2011, 01:04 AM
  4. VBA Code that creates new workbook that has 2 sheets and auto save
    By jasmin1279 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2011, 10:38 AM
  5. Help in compiling a mastersheet from various sheets
    By Excelcreep in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2011, 04:33 PM
  6. Subtotals in Mastersheet with Group-Sheets
    By Sultix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2009, 02:26 AM
  7. Copying sheets to a mastersheet Help needed
    By auspcs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2006, 07:42 AM

Tags for this Thread

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