Jason_Buda
10-02-2009, 09:49 AM
I am trying to write a macro that will sum the multiple columns where several similar cells occur. This table starts with room numbers, arch ref and description. Where these 3 items are the same i would like to sum the shop hours, finish hours, delivery hours and installation hours and place them in the first row where this room, arch ref and description occurs. Then delete the other rows that were summed. i have attached a spreadsheet that shows the data that i am starting with and the end result that i want it to look like. Any help that could be provided would be appreciated.
Thanks.
Thanks.