08-29-2008, 08:38 AM
|
|
Registered User
|
|
Join Date: 28 Aug 2008
Location: up north
Posts: 22
|
|
|
Get multiple answers depending on other text
Please Register to Remove these Ads
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?!
Last edited by P357; 08-29-2008 at 08:48 AM.
|
Linear Mode
