Thanks for taking a look.
I think if I try to explain what i am trying todo both questions will be answered.
On sheet1 I have things set up so each row is an entry. Each colum of that row is the number of times something was done. Example: Column A is always going to be the date column C will always be and ID number and columns E through BD are the diffrent services. A3 = 02/23/06 C3=991 E3 = 1 AD3 = 5. There may be 1600 rows over a weeks time. I want to pull out to another sheet each day by ID number. Where the trobule is 991 get 10 entrys on 02/23/06 and I need to total column E through BD. Then do the same for 993 on a diffrent sheet.
Hopefully this helps explain things.
Bookmarks