How to one cells variables as a serie to a column

[Guest]

I cant find the way out. I have a daily variable data in a single cell (say
in A1) ant I want to form a serie with using daily values of that cell.

(Variable)
Date Value
21.12.2006 400

(Series)
01.12.2006 300
02.12.2006 350
....
....
20.12.2006 420
21.12.2006 400

 

[Max]

That is first step. Thnx a lot.

You're welcome. Glad it helped.

Now the point is to do the same thing for a
daily variable next to the date.
The problem is that the second variable is
not increasing or decreasing.
Still working but no result.

Suggest you put the above in as a new posting, elaborating carefully how the
2nd "variable" in B1 is supposed to vary within the corresponding range in
B3:B33, in relation to the dates in A3:A33. As it stands here, based on
what's posted I've no guesses on the pattern.

---

 

[Guest]

Hi, I was checking your samples (pack no "1_zp_56_Samples_Max_04Nov2005.zip")
and I end up with a possible solution to my question in "randomization lotto
program" where you freeze the draws. But I was enable to extract what is good
for me with my GREAT 2-days macro knowledge. Any help from this point of view.

 

[Max]

Suggest you put in a new posting in excel.programming to gather responses
from those versed in vba. You could post the code used in the sample (It's
all documented in the Notes sheet in the sample), & explain what you would
like to do/make happen instead.