Hi,

Column A contains dates starting from A2:A500. H2 is where when i enter a
date , get some results in H3. I then manually type those results in column B
next to specific dates. I have to do this 500 times. Anyway to automate this?

H3 uses long sumproduct function along with some UDF which gets data from
other workbooks in a folder. Its not possible to enter this entire function
through column B.

Long time back i did it using Pivot table or something similar. Cant recall..

TIA