WHAT SCRIPT SHOULD DO:
There are 2 open Excel workbooks: Book1 and Book2. Script should grab data form [url removed, login to view](A2:B20) and place them to [url removed, login to view](C2:D20). VBA script would look like this:
Workbooks("[url removed, login to view]").Worksheets("Sheet1l").Range("C2:D20").Value = Workbooks("[url removed, login to view]").Worksheets("Sheet1l").Range("A2:B20").Value =
(it is not copy/paste, script should not select any range, nor interfere with other (currently) active worksheets.)
WHEN - TIME/TRIGGER/LOOP:
Script must be run every 20 second, but it must be aware of local computer time, and repeat the task on 18th, 38th and 58th second (in real time).
2 freelancers are bidding on average €27 for this job
I understand that you need to get translated 1 line VBA code with timer. We have team of python developer who can do this for you. Relevant Skills and Experience Python Proposed Milestones €23 EUR - Ball Park