Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Capturing by Time
I have dynamic data (which is constantly changing) in cells B1,C1 & D1. In
column A starting in cell A2 I have times listed from 1:00 to 2:00 by minute. I want the data which is being captured in row 1 to copy to the corresponding cell in the lower rows at the time listed ... i.e. at 1:00 the values at that time should appear in row 2 ... the data as of 1:01 should appear in row 3 etc ... What macro can be written to do this? -- Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Capturing by Time
You can use an OnTime Event macro. Such a macro can be configured to run
every minute. The macro would take the current values in B1:D1 and copy them to the first available empty slot in your data table. For details on making and using this type of macro, see: http://www.cpearson.com/excel/OnTime.aspx -- Gary''s Student - gsnu200759 "Ken" wrote: I have dynamic data (which is constantly changing) in cells B1,C1 & D1. In column A starting in cell A2 I have times listed from 1:00 to 2:00 by minute. I want the data which is being captured in row 1 to copy to the corresponding cell in the lower rows at the time listed ... i.e. at 1:00 the values at that time should appear in row 2 ... the data as of 1:01 should appear in row 3 etc ... What macro can be written to do this? -- Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing The Date Of When Data Is Inputted | Excel Discussion (Misc queries) | |||
Capturing a cell value as a function of a date | Excel Worksheet Functions | |||
Capturing Date | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Capturing a date field once only | Excel Worksheet Functions |