Results 1 to 2 of 2

Get multiple answers depending on other text

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2008
    Location
    up north
    Posts
    26

    Get multiple answers depending on other text

    I have a schedule with names on the left and days on the top row.
    My name cell(a1) is followed by the start time(b1), text[to](c1) and end time(d1)
    once again beside my name cell(a1), I have b2 as area of work.


    As of now, this all works perfectly.

    under the schedule, in the name column, I have a start time,
    end time(for the day), and then all the area of work like tech, sales, cash, etc...

    My question is: how can I make a macro that finds the start and end time of the day, and then finds what area of work in the left column, and then looks through the entire schedule to locate another one; once it finds it, it will add the start and end time as a continuing counter like: 8 to 5 would be 8,9,10,11,12,13,14,15,16,(because 5 is not work. you stop at that point.).
    Now that we have these numbers , it goes on to the next person that has the SAME area of work. it will essencially add a check for every hour worked.
    Then it verifies it with that day's time. If it matches, then we're good. if not, it gives a result "bad".


    I hope this is clear?!
    Attached Files Attached Files
    Last edited by P357; 08-29-2008 at 08:48 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pasting multiple lines of text into one cell
    By hoopz in forum Excel General
    Replies: 4
    Last Post: 07-11-2012, 08:28 PM
  2. Import Specific line from multiple text files
    By Vlad999 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-14-2008, 06:50 PM
  3. Count multiple rows (text) with multiple criteria (text)
    By alecabral08 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2008, 04:26 PM
  4. Replies: 12
    Last Post: 01-10-2008, 09:34 AM
  5. Replies: 3
    Last Post: 01-26-2007, 10:30 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