+ Reply to Thread
Results 1 to 5 of 5

Add Multiple Columns based on same criteria found in multiple columns

  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    Vero Beach, Florida
    MS-Off Ver
    Office 13
    Posts
    3

    Add Multiple Columns based on same criteria found in multiple columns

    I have a work schedule for each day of the week. Each day has three columns of information-1) the area and time working-COLUMN A 2) the total hours-COLUMN B 3) the employee assigned-COLUMN C.

    An employee can be listed in multiple times on any given day and can be assigned different areas (rows) over the work week.

    When preparing the schedule, I want to have a running total of hours I have assigned by employee to make sure that they are scheduled for the right amount of hours. Ideally, if I were able to have ALL the employees listed and as I modify the schedule their respective total hours would adjust accordingly.


    Help Please!
    Last edited by KathyBNelson; 08-29-2014 at 04:13 PM. Reason: Want to upload sample

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add Multiple Columns based on same criteria found in multiple columns

    copy all days (data) in 1 sheet.

    after that use a pivot table to analyze your data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-29-2014
    Location
    Vero Beach, Florida
    MS-Off Ver
    Office 13
    Posts
    3

    Re: Add Multiple Columns based on same criteria found in multiple columns

    Thanks for the response.

    I have thought of that but I am wanting it to be interactive at the time of setting the schedule.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add Multiple Columns based on same criteria found in multiple columns

    It looks like you get merged cells in your sheet.

    If so, don't work with merged cells, you get in trouble with it sooner or later.

  5. #5
    Registered User
    Join Date
    08-29-2014
    Location
    Vero Beach, Florida
    MS-Off Ver
    Office 13
    Posts
    3

    Re: Add Multiple Columns based on same criteria found in multiple columns

    You are right. I inherited this worksheet and have already passed that info along.

    Again, thank you for the info.

+ 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. Populating fields in multiple cells based on criteria in multiple columns
    By excelalways in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2014, 08:17 AM
  2. formulas for search based on multiple criteria in multiple columns
    By oneworld in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 06:57 AM
  3. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  4. [SOLVED] Deleting Duplicates Based on Multiple Criteria from Multiple Columns
    By Franklic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:31 PM
  5. Macro to Segregate the data based on Multiple Criteria's in Multiple Columns -Challenging!
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2012, 07:31 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