|DerbyDad03 - holly molly, thank you. I know just enough about xcel and html to understand what you are saying but I have no idea how to implement it.|
Since you asked, here is what I am trying to do.
In tab 1 I have a series of client names in column A. Lets say they are Mark, Mathew, Luke, John in lines 1, 2, 3, 4
In tab 2 (lets call it "Monday") I have set up 2 columns that allow me to insert a start time and an end time (8:00 am in column A and 9:00 am in column B, both line 1, and in column C the equation shows "60 min", also line 1. Then in column D I have written a data validation list that references tab 1, column A for my clients' names and allows me to select one of those clients names to appear in column C, line 1. All 4 of those columns work together in line 1 to show me a A) start time, B finish time, C total time spent, and D the client who is responsible for paying for that time that is represented by the name selected in the validation list.
For tab 2 "Monday", I then repeat the equation in line 1 into lines 2 - 15 (including validation lists) in essence, creating a time sheet for "Monday" that allows me up to 15 individual time sequences for up to 15 different clients on 15 lines.
I then created the exact same series of lines/columns in tabs 3, 4, 5, 6, 7, 8, for each day of the week. (I could put all 7 days in the same tab, but for now I have them individually).
The goal is to write macro in tab 1, column B, line 1 that will search JUST column D for ALL tabs 2-8, ALL lines 1-15 for the client name listed in tab 1 column A, line 1. THEN return all of the data for "total time" in column C in ALL of the tabs 2-8, ALL of the lines 1-15 for JUST the client referenced in Line 1 tab 1. This adds together all of the "total time" during that week for that particular client selected in line 1 tab1 .
I'd like to repeat everything in tab 1, line 1 for each of the 4 clients in lines 2-3.
Is that clear as mudd? I'd be happy to send you the spread sheet I have started already if that would help.
Thank you so much for your help.