Skip to main content
Question

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

  • January 18, 2022
  • 4 replies
  • 403 views
Y

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
    Forum|alt.badge.img+22
    • 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
    • Yallaling
    • Author
    • 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

    @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 & ConditionsCookie settingsAccessibility statement