+ Reply to Thread
Results 1 to 4 of 4

Need Help With Formula for Cells Copying Each Other

  1. #1
    Registered User
    Join Date
    12-07-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    3

    Need Help With Formula for Cells Copying Each Other

    Alright i'm going to try to explain this but its a little confusing given the circumstances of what i need

    I have a excel sheet that is for scheduling tradesman during certain time slots. I have it set up based on trade. However, some of the tradesman cross trades.

    So when i fill a slot for Handyman A say for 8am I need his linked cell in Cabling A for 8am to also fill in.

    And vice versa, if i fill Cabling A @ 12pm, Handyman A @ 12pm needs to also fill in.

    I have some guys that cross into 3 or 4 different trades too. So he would have 4 cells that need to be linked to each other.

    Is this possible? Any help or suggestions?

    Thanks in advance everyone!

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Need Help With Formula for Cells Copying Each Other

    Post a non data-sensitive spreadsheet, fill with dummy data if necessary.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    12-07-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need Help With Formula for Cells Copying Each Other

    See below

    Trades/Techs AM (8-12PM) PM (12-4) AM (8-12PM) PM (12-4)
    HVAC 1 X X
    HVAC 2 X X
    HVAC 3
    HVAC 4

    Plumbing 1 X X
    Plumbing 2
    Plumbing 3
    Plumbing 4
    Plumbing 5

    Electrical 1 X X
    Electrical 2 X X
    Electrical 3
    Electrical 4
    Electrical 5

    Handyman 1
    Handyman 2
    Handyman 3
    Handyman 4
    Handyman 5

  4. #4
    Registered User
    Join Date
    12-07-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need Help With Formula for Cells Copying Each Other

    Test Sheet.xlsx

    Nvm let me attach, i think that's what you meant.

    The red guys are linked. So when i x one of their time slots i want all of them to x out. Same thing with the yellow.

    I have them manually linked on this one to show you what i'm trying to accomplish.

+ 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. Copying formula to other cells
    By themole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2014, 06:51 PM
  2. [SOLVED] Copying a formula down but skipping cells
    By dnsmc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2013, 03:05 AM
  3. VBA Formula for copying cells and adding new ones
    By drsteffa in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-07-2012, 05:32 AM
  4. Replies: 1
    Last Post: 04-30-2012, 10:01 PM
  5. copying cells with formula
    By coot in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-27-2011, 07:41 AM

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