hi there

i am having a bit of trouble with a consolidation, the prob is i have two columns a and b one is date one is value in hours i want a piece of code that looks through column a(date) and every time the date is the same it will add up the same cells in column b leaving me with one date and one value of hours

this is for a macro i am trying to write

thanks