Macro to auto-copy a cell from particular column and paste it in a particular cell in a different column at particular times. This macro should automatically conduct these operations based on actual times from the computer
Example: when it is 5am, the macro copies the value in cell k4 and pastes it in m1, then when it is 6am the macro copies the value in cell k4 and pastes it in m2, then when it is 7am the macro copies the value in cell k4 and pastes it in m3, and so on!
Please assist with model code.
Hi nuel,
It isn't practical to do this as it requires the macro to be running constantly in order that it can check the time.
What exactly is the purpose of copying these cells at specific times? Perhaps there is another solution.
Can you please supply sample data/workbook to help us assist you.
Regards
Phil
This op has crossposted this request at https://www.ozgrid.com/forum/forum/why-is-vba-running-slowly-forums/excel-vba-macros/1210360-macro-to-auto-copy-a-cell-and-paste-it-in-a-another-cell-at-particular-times
and
and
