Check out your other post.

Pete

On Nov 30, 6:39*pm, Cristal wrote:
I am trying to change hourly data to include data points for every 15
minutes. *

What I have * * * * * * * * * * * * * * *What I need
Time * * * * * * * * * * *Data * * * * Time * * * * * * * * * * *Data
3/1/2009 0:00 * * * *99.12 * * * *3/1/2009 0:00 * * * *99.12
3/1/2009 1:00 * * * *99.07 * * * *3/1/2009 0:15 * * * *99.12
* * * * * * * * * * * * * * * * * * * * * * 3/1/2009 *0:30 * * * *99.12
* * * * * * * * * * * * * * * * * * * * * * *3/1/2009 0:45 * * * 99.12
So, 1) I need to create data points for time and time within my existing data
2) I need to copy data that occurs in one cell (99.12 for example b2) four
times before copying the next value (00.07 for example b3)

My data is for 9 months, too time intensive to do by hand.