+ Reply to Thread
Results 1 to 8 of 8

Master Sheet That Edits Child Sheets?

  1. #1
    Registered User
    Join Date
    12-22-2023
    Location
    Newcastle, England
    MS-Off Ver
    2019
    Posts
    3

    Master Sheet That Edits Child Sheets?

    Hi all,

    I'm managing a workbook that works as an employee tracker. Each employee has their own sheet with the same information being inputted- personal details, absences/lateness, disciplinary records etc. The layout is identical for each sheet, it's just the data that differs.

    My problem is every time I want to change something such as conditional formatting in a specific field, or which range a drop-down pulls values from, I have to edit this for every single sheet (and we have a lot of employees!) My question to you is: Is it possible to set one blank template as the "master" sheet, that any child copies will automatically pull these changes from? Would save me a ton of time if so!

    (For clarity's sake, I usually make quick changes to the file in Google Sheets but will use Excel for larger edits- it's referenced by multiple users in several locations.)

    Many thanks!
    Attached Files Attached Files
    Last edited by snoozyblue; 12-22-2023 at 07:45 AM. Reason: adding sample workbook

  2. #2
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    253

    Re: Master Sheet That Edits Child Sheets?

    Dear snoozyblue,

    kindly attached the sample workbook

  3. #3
    Registered User
    Join Date
    12-22-2023
    Location
    Newcastle, England
    MS-Off Ver
    2019
    Posts
    3

    Re: Master Sheet That Edits Child Sheets?

    Hi sudbhavani,

    I've attached the blank employee template I'm referring to, but this is a general enquiry about functionality I'm not sure how relevant it's going to be.

  4. #4
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    253

    Re: Master Sheet That Edits Child Sheets?

    ok now what is your requirement give a full explanation of what cell u want get the result

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Master Sheet That Edits Child Sheets?

    Try this way.

    copy
    select all tabs
    past special
    format
    Last edited by popipipo; 12-22-2023 at 09:04 AM.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  6. #6
    Registered User
    Join Date
    12-22-2023
    Location
    Newcastle, England
    MS-Off Ver
    2019
    Posts
    3

    Re: Master Sheet That Edits Child Sheets?

    Quote Originally Posted by sudbhavani View Post
    ok now what is your requirement give a full explanation of what cell u want get the result
    I explained this in my original post =) I'm not looking to calculate anything, my question is about formatting multiple sheets from one master and whether it's possible.

    Quote Originally Posted by popipipo View Post
    Try this way.

    copy
    past special
    format
    That's still editing every individual sub-sheet separately though, and is what I'm already doing!

  7. #7
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Master Sheet That Edits Child Sheets?

    select all tabs

    I edited my answer.

  8. #8
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    253

    Re: Master Sheet That Edits Child Sheets?

    Dear popipipo

    I think there might still be some confusion in your question. If you're looking to apply a specific format to an entire sheet. Using VBA in Excel, Here's an example:

    Please Login or Register  to view this content.
    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)

Similar Threads

  1. VB Macro to compare and update data on Master Sheet from Child Sheet
    By 0bliviousDork in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2022, 04:31 AM
  2. [SOLVED] Google Sheets: Update slave/child sheets from Master/Parent sheet
    By JGREEN17 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-29-2021, 03:03 PM
  3. Update slave/child sheets from Master/Parent sheet
    By JGREEN17 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2021, 02:45 PM
  4. update master excel sheets from child sheets
    By Big_Kev007 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-23-2020, 09:38 AM
  5. VBA Code for mirroring data bidirectionally from master sheet to child sheets
    By chandhana21 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-11-2017, 08:54 PM
  6. Help with Master/Child sheet, inserting new row if criteria met
    By LaLaMcFly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-30-2014, 03:48 PM
  7. Copy Rows from Master Sheet to Child Sheets Base on Values
    By Traquair in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2010, 03:19 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