I am currently involved in restarting a previously shut down power plant. On the computers in the control room there are Excel spreadsheets that contain realtime data feeds from locations in the plant using a program called Rockwell Software. This works great but what i need it Excel to do is record the data. For example cell A5 updates every 5 secs with information taken from the plant. I need starting at 12:00:00am everymorning say cell A6 to record the value in A5 then at 12:00:30am cell A7 to record the new value in A5 and so on every 30 secs for the entire day. Also at the end of the day I need to have the recorder start back at A6 @ 12:00:00am that morning and right over the previous days data. I was hoping to use the NOW() function as a timer.