Hi there,

Is there a macro where I can calculate data from column H (all numbers), based on the dates in column K?

Obviously on another sheet I'd have a list of all the dates of the year in column A, then in column B I want to calculate the total number entered into cells in column H if the dates in column K equal to the dates in Column A of spreadsheet 2.

Hopefully that makes sense. I know there are formula's to do that but they make my workbook run a bit slower.

Thanks