Skip to main content

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