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

You can use the DataTable command

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"XKruodo" wrote in message
...
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