Hi,

I need some help with excel macro!
I have two workbooks. Now I need to sum all cells with some date criteria
from first workook
and result must be inserted in cell in second workbook (for example in cell
A1)

WorkBook1 data example

Column B (dates) Column C (payroll)
12.05.2005 1200
12.05.2005 5000
14.05.2005 3100
14.05.2005 8800
17.05.2005 3550
....


For example: sum all values in column C where date in column B is 12.05.2005
and put result in workbook 2 in cell A1

Thanks for help.