+ Reply to Thread
Results 1 to 6 of 6

Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    13

    Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

    This is a little hard to explain so I've uploaded a file so hopefully somebody on here can help me resolve this fairly quickly!
    (Click here to download)


    Now let me explain what I'm trying to do.

    I have several sheets
    1) Groups: This is where all the groups and users are
    2) Section Master: This is where all the user's will be put to their sections
    3) Section 1, 2, 3 & 4: This is so each section can view where their users have been placed

    What I'm trying to do:
    If a user is moved section it needs to be changed on their corresponding group.

    So, If User1 (who belongs to Group 1)is moved from Section A to Section B then on the Group 1 sheet the user needs to be moved to the selected area.

    Fairly hard to explain unless you have the sheet to understand.

    But the Section Master sheet can be the only 1 filled out then all the people who run the groups just need to look at thier groups to see what each person will be doing.

    So is there anyway I can link cells across all sheets but only display the groups?

    (Easy way to understand, If I have a master calendar with all the months on a sheet and I enter data into say Feb 14th then at the bottom i have sheets, Go to the February sheet and on the 14th the data will be there)

    I know this might be hard to understand but if anybody can help it will be very much appreciated!

  2. #2
    Registered User
    Join Date
    06-18-2014
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

    I'm not quite understanding the need for the "Groups" sheet.

    Am I right in assuming that you want to do all the placing of Users into Sections on the Section Master Sheet and then have that information transferred to the individual Section Master sheets?

    It's quite difficult to understand what you're trying to do when there is no sample data on the sheet.

  3. #3
    Registered User
    Join Date
    02-13-2013
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

    Quote Originally Posted by Pianoman23 View Post
    I'm not quite understanding the need for the "Groups" sheet.

    Am I right in assuming that you want to do all the placing of Users into Sections on the Section Master Sheet and then have that information transferred to the individual Section Master sheets?

    It's quite difficult to understand what you're trying to do when there is no sample data on the sheet.
    The 'Groups' Sheet is not really needed, Just used for us for reference.

    and you are right in what you are saying.

    I'm wanting to fill out the MASTER sheet with all the user's we have.
    Then I can say print out the Group 3 & the Group 3 manager knows where to send his staff.

    So, If you say for example.. I'm in charge of Group A, I plan ALL the groups out on the MASTER sheet, I then print out each individual sheet and give Group A sheet to me, Group B to that section Manager and so on.
    Then each 'Group Manager' knows where to send their staff.

    It just save's us filling out 10 sheets when we can fill out 1 !

    Anyways, I've updated the example file to hopefully make it easier to understand.

    (Can be downloaded here)

  4. #4
    Registered User
    Join Date
    06-18-2014
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

    CHANGE CELL EXAMPLE (2).xlsxHere's a quick fix so that any changes you make on the master sheet will be reflected in the group master sheets.

    I suspect that the best way to do it would be via vba code operating from a command button on the master sheet. That way you could avoid the inevitable gaps in lists and apply your back color code when you make changes.

    Hope this helps

  5. #5
    Registered User
    Join Date
    02-13-2013
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

    Quote Originally Posted by Pianoman23 View Post
    Attachment 326777Here's a quick fix so that any changes you make on the master sheet will be reflected in the group master sheets.

    I suspect that the best way to do it would be via vba code operating from a command button on the master sheet. That way you could avoid the inevitable gaps in lists and apply your back color code when you make changes.

    Hope this helps
    This is EXACTLY what I needed!

    Thank you so much!

  6. #6
    Registered User
    Join Date
    06-18-2014
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Major help needed ! If cell moved on "MASTER" sheet - move on other sheets

    No worries. Glad to be of help.

    If you're happy please click the Add Reputation button.

    Thanks

+ 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. [SOLVED] Working with multiple sheets, need the "Master Sheet" to collect all its data
    By switzd0d in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-20-2014, 10:51 AM
  2. [SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 02:11 PM
  3. Replies: 3
    Last Post: 05-31-2013, 05:16 AM
  4. Copy Specific Columns (Named ones) from different sheets to a new "master" sheet
    By aribe88 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-11-2013, 04:10 PM
  5. creation of "master sheets" or "template"?
    By CJPB in forum Excel General
    Replies: 2
    Last Post: 12-15-2010, 12:24 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