Create Macro VBA in MS Excel to trf data from one excel to another and then autorun another Macro A,
Budget: ₹1,500 – ₹12,500 INR
Create a Macro which does the following - Note excel FILE A and excel FILE B will be open at all times.
When I click on “AUTORUN” in FILE B (tab BOT) then:
Step 1: Copy incremental data till last sr no. (using unique Sr no.) from File A (Tab Type 1, Type2, Type 3, Type4, ) to File B (Sheet 1)
e.g. Copy Sr. no. 11729 to 11737.. from File A to File B (Pls note although serial nos. end at 11737, the formulas continue in additional rows in File A)
Step 2: Click on Run Whatsapp Bot in File B (tab BOT)
Step 3: Copy data marked as “Error” in File B (Tab Error)
Step 4: Autosave the FILE B and then Autorun Step 1 (after a defined specified period e.g 1 hour) – give me the option to change the autorun time gap - During Step 1 – only copy incremental data from the last Sr. no. in tab Sheet 1 in File B.. to latest Sr. no. from File A
NOTE:
Step 5: In case I press “ERROR-RERUN” in Fie B (Error tab), then the system stops the AUTORUN from tab BOT in File B, and copies the data from ERROR tab to Sheet 1 Tab (in File B)
Step 6: then Continue with Step 2 - and copy its relevant result output data in ERROR Tab, next to the relevant column in addition to the BACKUP tab
Step 7: Continue with Step 2 , 3, 4 automatically
Step 8: Give another Macro Click button to STOP the Auto-run if needed.
Please provide codes which are userfriendly so that I can adjust (A) the timer for Step 4 and (B) change the tab to be selected in File A
When I click on “AUTORUN” in FILE B (tab BOT) then:
Step 1: Copy incremental data till last sr no. (using unique Sr no.) from File A (Tab Type 1, Type2, Type 3, Type4, ) to File B (Sheet 1)
e.g. Copy Sr. no. 11729 to 11737.. from File A to File B (Pls note although serial nos. end at 11737, the formulas continue in additional rows in File A)
Step 2: Click on Run Whatsapp Bot in File B (tab BOT)
Step 3: Copy data marked as “Error” in File B (Tab Error)
Step 4: Autosave the FILE B and then Autorun Step 1 (after a defined specified period e.g 1 hour) – give me the option to change the autorun time gap - During Step 1 – only copy incremental data from the last Sr. no. in tab Sheet 1 in File B.. to latest Sr. no. from File A
NOTE:
Step 5: In case I press “ERROR-RERUN” in Fie B (Error tab), then the system stops the AUTORUN from tab BOT in File B, and copies the data from ERROR tab to Sheet 1 Tab (in File B)
Step 6: then Continue with Step 2 - and copy its relevant result output data in ERROR Tab, next to the relevant column in addition to the BACKUP tab
Step 7: Continue with Step 2 , 3, 4 automatically
Step 8: Give another Macro Click button to STOP the Auto-run if needed.
Please provide codes which are userfriendly so that I can adjust (A) the timer for Step 4 and (B) change the tab to be selected in File A