Get multiple answers depending on other text

P357 · #1 08-29-2008, 08:38 AM

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?!

P357 · #2 08-29-2008, 10:44 PM

i hope this is clear enough? I just want to finsih this this weekend.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Specific line from multiple text files	Vlad999	Excel Programming	9	08-14-2008 06:50 PM
Count multiple rows (text) with multiple criteria (text)	alecabral08	Excel Worksheet Functions	7	07-21-2008 04:26 PM
Pasting multiple lines of text into one cell	hoopz	Excel Miscellaneous	3	01-15-2008 03:39 PM
VLOOKUP variation to yield multiple text values for same customer not just first text	joewood	Excel Worksheet Functions	12	01-10-2008 08:34 AM
How to combine text in multiple cells? (problems with importing from html table)	kayak_pirate81	Excel General	3	01-26-2007 09:30 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)