match one column with dates to several colums with dates, copy pas
 

I will try to explain what I want vba to do.
I cannot find out my self, even if I tried hard.

In a sheet I have dates i colum a, and numbers in some of the cells in
column d
the dates are in sets of
5 weeks dates
id. est

A d
28-06-2008. 7
29-06-2008 6,3
.. 3
.. .
.. .
.. 8
31-07-2008
some rows with data then
28-6-2008.
29-06-2008
..
..
..

31-07-2008
some rows with data then the same as apove app. 2o times

Colum a changes every 5 weks and new number in column d.
the numbers i d er not the same in each set, and not in the same row in
each set.

in column h I have dates (i est dates of january) in column j nothing.
in column k Ii have dates(i est dates of february) in column l nothing
and so forth to the end of the year(i. est starting in column h 24 columns
every second column i empty., second last colum is december)

This goes for each set of dates i colum a., and starts in the same row as
the sets starts in a





------------------
A d h .......... s t u
v
28-06 6,3 02-01 01- 06 01-07
29-06 3 . .
30-06 . 28-06 6,3
.. . . 29-06 3
.. 30-06
31-07 8 31-01 31-07
8
some rows with data then
28-6-2008.
29-06-2008
..
..
..

31-07-2008
some rows with data then the same as apove app. 2o times

Before the macro run nothing is column t or in v.
After the macro has run the numbers should be as showen above.

I hope it is not too unclear what i mean.

Hope for help












--
bbbb2803

match one column with dates to several colums with dates, copy pas
 

correktion se below
--
bbbb2803



"Torben" skrev:

I will try to explain what I want vba to do.
I cannot find out my self, even if I tried hard.

In a sheet I have dates i colum a, and numbers in some of the cells in
column d
the dates are in sets of
5 weeks dates
id. est

A d
28-06-2008. 6,3
29-06-2008 3 . . .
. .
. .
31-07-2008 8
some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Colum a changes every 5 weks and new number in column d.
the numbers i d er not the same in each set, and not in the same row in
each set.

in column h I have dates (i est dates of january) in column j nothing.
in column k Ii have dates(i est dates of february) in column l nothing
and so forth to the end of the year(i. est starting in column h 24 columns
every second column i empty., second last colum is december)

This goes for each set of dates i colum a., and starts in the same row as
the sets starts in a





------------------
A d h .......... s t u v
v
28-06 6,3 02-01 01- 06 01-07
29-06 3 . . .
30-06 . . 28-06 6,3 .
. . . 29-06 3 .
. . . 30-06 .
31-07 8 31-01 31-07 8

some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Before the macro run nothing is column t or in v.
After the macro has run the numbers should be as showen above.

I hope it is not too unclear what i mean.

Hope for help












--
bbbb2803

match one column with dates to several colums with dates, copy
 

My correttion went totally wrong.

What I menan is that the 8 i column a under 31-7 skuld beei incolumn v in
the row with 31-7
--
bbbb2803



"Torben" skrev:

correktion se below
--
bbbb2803



"Torben" skrev:

I will try to explain what I want vba to do.
I cannot find out my self, even if I tried hard.

In a sheet I have dates i colum a, and numbers in some of the cells in
column d
the dates are in sets of
5 weeks dates
id. est

A d
28-06-2008. 6,3
29-06-2008 3 . . .
. .
. .
31-07-2008 8
some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Colum a changes every 5 weks and new number in column d.
the numbers i d er not the same in each set, and not in the same row in
each set.

in column h I have dates (i est dates of january) in column j nothing.
in column k Ii have dates(i est dates of february) in column l nothing
and so forth to the end of the year(i. est starting in column h 24 columns
every second column i empty., second last colum is december)

This goes for each set of dates i colum a., and starts in the same row as
the sets starts in a





------------------
A d h .......... s t u v
v
28-06 6,3 02-01 01- 06 01-07
29-06 3 . . .
30-06 . . 28-06 6,3 .
. . . 29-06 3 .
. . . 30-06 .
31-07 8 31-01 31-07 8

some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Before the macro run nothing is column t or in v.
After the macro has run the numbers should be as showen above.

I hope it is not too unclear what i mean.

Hope for help












--
bbbb2803

match one column with dates to several colums with dates, copy pas
 

If desired, send your workbook to my address below along with snippets of
these messages and before/after examples. I will try to take a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Torben" wrote in message
...
I will try to explain what I want vba to do.
I cannot find out my self, even if I tried hard.

In a sheet I have dates i colum a, and numbers in some of the cells in
column d
the dates are in sets of
5 weeks dates
id. est

A d
28-06-2008. 7
29-06-2008 6,3
. 3
. .
. .
. 8
31-07-2008
some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Colum a changes every 5 weks and new number in column d.
the numbers i d er not the same in each set, and not in the same row in
each set.

in column h I have dates (i est dates of january) in column j nothing.
in column k Ii have dates(i est dates of february) in column l nothing
and so forth to the end of the year(i. est starting in column h 24 columns
every second column i empty., second last colum is december)

This goes for each set of dates i colum a., and starts in the same row as
the sets starts in a





------------------
A d h .......... s t
u
v
28-06 6,3 02-01 01- 06 01-07
29-06 3 . .
30-06 . 28-06 6,3
. . . 29-06 3
. 30-06
31-07 8 31-01 31-07
8
some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Before the macro run nothing is column t or in v.
After the macro has run the numbers should be as showen above.

I hope it is not too unclear what i mean.

Hope for help












--
bbbb2803

match one column with dates to several colums with dates, copy pas
 

This formula applied to cell U51 and copied down to U85 will work. Then copy
to col W,Y, AA, etc
=IF(ISNA(MATCH(T51,$A$51:$A$85)),"",IF(INDEX($H$51 :$H$85,MATCH(T51,$A$51:$A$85))0,"F",IF(INDEX($I$5 1:$I$85,MATCH(T51,$A$51:$A$85))0,"FF","")))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
If desired, send your workbook to my address below along with snippets of
these messages and before/after examples. I will try to take a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Torben" wrote in message
...
I will try to explain what I want vba to do.
I cannot find out my self, even if I tried hard.

In a sheet I have dates i colum a, and numbers in some of the cells in
column d
the dates are in sets of
5 weeks dates
id. est

A d
28-06-2008. 7
29-06-2008 6,3
. 3
. .
. .
. 8
31-07-2008
some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Colum a changes every 5 weks and new number in column d.
the numbers i d er not the same in each set, and not in the same row in
each set.

in column h I have dates (i est dates of january) in column j nothing.
in column k Ii have dates(i est dates of february) in column l nothing
and so forth to the end of the year(i. est starting in column h 24
columns
every second column i empty., second last colum is december)

This goes for each set of dates i colum a., and starts in the same row as
the sets starts in a





------------------
A d h .......... s t u
v
28-06 6,3 02-01 01- 06 01-07
29-06 3 . .
30-06 . 28-06 6,3
. . . 29-06 3
. 30-06
31-07 8 31-01
31-07
8
some rows with data then
28-6-2008.
29-06-2008
.
.
.

31-07-2008
some rows with data then the same as apove app. 2o times

Before the macro run nothing is column t or in v.
After the macro has run the numbers should be as showen above.

I hope it is not too unclear what i mean.

Hope for help












--
bbbb2803