organizing a large amount of data into a table
 

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

organizing a large amount of data into a table
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"oakman " schrieb im
Newsbeitrag ...
Greetings to all and thank you in advance!
I have a sheet "MAY" that includes every single day in may up to the
most current date. Each day is broken into 24 hours. So, for day
5/1/2004 I have in column E hour one to 24. The same is repeated for
5/2/2004 and so forth and so on up to the most current day. I have
another sheet "Table" in which I have the number 1-24 in the rance B1
to Y1. I am trying to take the value of the cell adjacent to hour 1
for
each day in "MAY" and place it in
"TABLE" cell B3 down to whatever day I have data for so far. I would
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 Sub


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

organizing a large amount of data into a table
 

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

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