kinda complicated need help

ok i'm trying to do a formula....here's what it will kinda look like I guess

I've got a data range and a monthly amount I needed into each data range.

i.e.

01012006 03312006 $5.00 Jan Feb Mar

03012006 03312006 $8.00 Mar

so in this example I would need to post $5.00 under jan, feb, mar,
and in the next example i would need to post the $8.00 to just under Mar

And this is for lots of data like 65,000 different profiles...

Originally Posted by rjahr01

ok i'm trying to do a formula....here's what it will kinda look like I guess

I've got a data range and a monthly amount I needed into each data range.

i.e.

01012006 03312006 $5.00 Jan Feb Mar

03012006 03312006 $8.00 Mar

so in this example I would need to post $5.00 under jan, feb, mar,
and in the next example i would need to post the $8.00 to just under Mar

And this is for lots of data like 65,000 different profiles...

Hi rjahr01,

Can you post a sample of what you have got, and the result you are trying to achieve to only it is difficult to understand your question

oldchippy

rjahr01,

Assuming your data is in columns A1:C65000 with headers in row 1. (A=Start Date, B=End Date and C=Amount). You could set up a grid of your months in G1:R1 (Jan - Dec) entered as January 1, 2006.....December 1, 2006. In G2 enter,

=IF(AND(G$1>=$A2,G$1<=$B2),$C2,"")

Copy across to R2 and down your list of data as needed.

HTH

Steve

so the top one is done, but the info is for the most part manually entered, I would like to create a forumla for it. Now the hard part is, if they were only active for the month of febuary, it needs to post only in febuary and not in the begining of the year (worksheet)

so this is the IF and statement I used

=IF(AND(F$1>=DATE(LEFT($A2,4),MID($A2,5,2),RIGHT($A2,2)),F$1<=DATE(LEFT($B2,4),MID($B2,5,2),RIGHT($B2,2))),$E2/$C2,"")

and this is the one i used so i could run it into a macro over any numerous amount of files, so that the leftover formula's appear as blanks instead of #Value's

And then I rana macro for it and clicked and dragged it and stopped the macro so she's happy now....whew that was a lot of work.