|
|
|
||||||||||||
|
|||||||
| Register | FAQ | Forum Rules | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
![]() |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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?! Last edited by P357; 08-29-2008 at 08:48 AM. |
|
#2
|
|||
|
|||
|
i hope this is clear enough? I just want to finsih this this weekend.
|
![]() |
| Bookmarks |
New topics in Excel Programming
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
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 |