LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I convert column of dates to Hebrew dates Joe Golden Excel Discussion (Misc queries) 11 May 14th 23 07:45 PM
How do I post specific dates into a colums labled only by Year? hardlook Excel Worksheet Functions 3 June 13th 08 11:50 PM
Find date, create new workbook, copy lines with same dates in column H littleme Excel Programming 2 August 23rd 07 05:07 PM
how do I sort a column of random dates into Consecutive dates Rob Gibson Excel Worksheet Functions 2 June 12th 07 05:10 AM
How to count dates in a column between 2 dates deaconj999 Excel Programming 6 April 15th 07 08:54 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"