Question

Best way to Copy data from one excel file to other excel file.

  • 18 January 2022
  • 4 replies
  • 49 views

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


4 replies

Userlevel 5
Badge +9

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