Automate calculation...

X

XKruodo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interest Calculations 6
SUMPRODUCT MISSING SOME ITEMS 11
Working Days of Week and DUE DATE for PAYMENT 4
sumproduct with 4 conditions 1
Reporting Info to New Sheet 3
now() sumproduct. 1
Date calculation and possible vlookup 1
Repeat formula for all cells in whole column 1

Top