organizing a large amount of data into a table

[oakman]

Greetings to all and thank you in advance!
I have a sheet "MAY" that includes every single day in may up to th
most current date. Each day is broken into 24 hours. So, for da
5/1/2004 I have in column E hour one to 24. The same is repeated fo
5/2/2004 and so forth and so on up to the most current day. I hav
another sheet "Table" in which I have the number 1-24 in the rance B
to Y1. I am trying to take the value of the cell adjacent to hour 1 fo
each day in "MAY" and place it in
"TABLE" cell B3 down to whatever day I have data for so far. I woul
like to do this for every hour if possible.
This is what I have for code so far:
Sub Hourly_Data()
Dim i as Interger
i=1
Sheets("MAY").Select
Range ("E1").Select
Do Until Range (i+23)=""
Cell.offset (0,+9)= Worksheets ("TABLE").Range("B3:B36")
Loop
End Su

 

[Frank Kabel]

Hi
maybe this gives you a starting point:
http://www.rondebruin.nl/copy5.htm

 

[oakman]

Thank you very much Frank!
You know, upon taking a walk and thinking about it some more;
actually wondered whether filtering might be the way to go. However,
still felt that there was a missing piece, but the link you hav
provided is perfect