Posted the jist of this message in another earlier post (see below) but am getting a little desperate for some genuine learned responses.

Hi all. I have a spreadsheet and have so far managed to build some code which upon the workbook open event, copies rows "hourly" from sheet "Master" to sheet "Backup".

Below is a snippet of what I've used so far:


Private Sub Workbook_Open()


Application.OnTime TimeValue("06:00:00"), "BACKUP1"
Application.OnTime TimeValue("07:00:00"), "BACKUP2"


End Sub
In a standard module I also have this code below:


Sub BACKUP1()
'
' BACKUP1 Macro
' Macro recorded 5/4/2013 by xxx
'


'
Application.ScreenUpdating = False
Range("A2:J5").Select
Selection.Copy
Sheets("BACKUP").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Application.ScreenUpdating = True
End Sub
Below is an example of what I'd really like my code to do. Column (i) in my master sheet contains "times" on each row and I'd really like to make my code copy each row from my master sheet to my backup sheet.

I'd like to "only" copy each row if the time in column (i) matches the current time. For example, once the current time is 1:30, row 1 copies across to my backup sheet and when the current time is 5.30, that row copies across to my backup.
Not sure how to make column (i) a variable row by row to copy across.


a b c d e f g h i j
1:30
5.30
8:00
21:00

I should add, although the existing code I have which copies data from my master sheet to my backup works very well, it would be so much more efficient to me to use the times in column (i) as a trigger point or a variable to copy rows from sheet to sheet as the times in column (i) constantly updates up the point of column (i) matching the current time which I have stored in a cell using = now()

Please help, some genuine guru advice much appreciated.....