I tried using keystrokes like open excel go to cell, ctrl a and ctrl c then open other excel go to cell then ctrl v. but its not working for me. i don't want to use database action. Please guide me
Hi @Yallaling Bansode ,
If you are not comfortable with Database you can go for VB Scripting.
Please can you guide to write VB Script
use Append Workbook or worksheet from Excel Advanced Package based on ur requirement.
@Yallaling Bansode
You can achive this using Python script as well ,. Follow below article
https://www.geeksforgeeks.org/python-how-to-copy-data-from-one-excel-sheet-to-another//p>
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.