Juriemagic
10-01-2015, 02:33 AM
Hi good people!,
I have searched and googled, but came up with empty hands..please help me with this little problem?
I have a sheet with data..(no surprise )..I want this data logged (copied and pasted) to different cells at specific days and times. What I have done was enter the 4 dates (on which the macro must fire), and times in 4 cells. in the 5th cell I have the formula "now()"..In the 6th cell I have a formula that will give a "1" as output when the "now" formula matches any of the four dates/times. when the cell changes to 1, I want a macro fired which will do the copy and paste actions..
What I am battling with is getting the sendkeys function to execute lets say every 30 sec..Please will somebody show me the way?..OR of course, if there is a better solution, I will also gladly welcome that..Thank you all..
I have searched and googled, but came up with empty hands..please help me with this little problem?
I have a sheet with data..(no surprise )..I want this data logged (copied and pasted) to different cells at specific days and times. What I have done was enter the 4 dates (on which the macro must fire), and times in 4 cells. in the 5th cell I have the formula "now()"..In the 6th cell I have a formula that will give a "1" as output when the "now" formula matches any of the four dates/times. when the cell changes to 1, I want a macro fired which will do the copy and paste actions..
What I am battling with is getting the sendkeys function to execute lets say every 30 sec..Please will somebody show me the way?..OR of course, if there is a better solution, I will also gladly welcome that..Thank you all..