Skip to main content
Y
Yallaling
Navigator | Tier 3
January 18, 2022
Question

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

  • January 18, 2022
  • 4 replies
  • 446 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

    C
    Most Valuable Pathfinder
    ChanduMohammadMost Valuable Pathfinder
    Most Valuable Pathfinder
    January 18, 2022

    Hi @Yallaling Bansode​ ,

     

    If you are not comfortable with Database you can go for VB Scripting.

    Chand
    Y
    YallalingAuthor
    Navigator | Tier 3
    January 18, 2022

    Please can you guide to write VB Script

    D
    Diansh
    Cadet | Tier 2
    January 18, 2022

    use Append Workbook or worksheet from Excel Advanced Package based on ur requirement.

    A
    Most Valuable Pathfinder
    Akshaykumar MoreMost Valuable Pathfinder
    Most Valuable Pathfinder
    January 19, 2022

    @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>

     

    Terms & ConditionsAccessibility statement