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

One way ..

Assuming the reference date is entered in A1, eg: 21-Dec-2006

Place in say, A3:
=IF(DATE(YEAR($A$1),MONTH($A$1),ROW(A1))$A$1,"",D ATE(YEAR($A$1),MONTH($A$1),ROW(A1)))

Copy A3 down by 31* rows to A33
*to cater for the maximum days per any month of the year

A3:A33 will return the required results,
ie an auto-fill from the 1st till the date entered in A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"noyau" wrote:
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

Format A3 as date (to taste) before copying down to A33
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

That is first step. Thnx a lot. 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.


"Max" wrote:

One way ..

Assuming the reference date is entered in A1, eg: 21-Dec-2006

Place in say, A3:
=IF(DATE(YEAR($A$1),MONTH($A$1),ROW(A1))$A$1,"",D ATE(YEAR($A$1),MONTH($A$1),ROW(A1)))

Copy A3 down by 31* rows to A33
*to cater for the maximum days per any month of the year

A3:A33 will return the required results,
ie an auto-fill from the 1st till the date entered in A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"noyau" wrote:
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

"noyau" wrote
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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" wrote:

"noyau" wrote
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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"noyau" wrote in message
...
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 unable [corrected] to
extract what is good
for me with my GREAT 2-days macro knowledge. Any help from this point of
view.