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

--
Message posted from http://www.ExcelForum.com