+ Reply to Thread
Results 1 to 12 of 12

Transfer data between workbooks .

  1. 05-26-2025, 02:46 PM #1
    Danilo Flaiban
    Danilo Flaiban is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 365
    Posts
    82

    Transfer data between workbooks .

    Good afternoon, everyone
    I need a macro that checks column E in the 2 worksheets of the Customer Balance workbook:
    If it is Zero , or with a lower value than column D , transfer certain columns to another worksheet , in another workbook .
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-26-2025, 03:38 PM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: Transfer data between workbooks .

    See next code with some cosmetic changes
    It assumes that all files are loaded in Excel
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by PCI; 05-26-2025 at 03:59 PM. Reason: Complement for border drawing
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 05-26-2025, 04:34 PM #3
    MikeVol
    MikeVol is offline
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    578

    Re: Transfer data between workbooks .

    Hello @Danilo Flaiban. Another option for you based on the code that @PCI provided you above, rewritten using an array that speeds up the macro on large amounts of data. If @PCI doesn't mind, of course. The second workbook (Customer balance.xlsx) does not have to be open, the code will open and close it automatically. 
    Please Login or Register  to view this content.
    Good luck.
    Last edited by MikeVol; 05-26-2025 at 04:41 PM. Reason: Update post
    NOTE: As the original poster/owner, only you can mark your thread as SOLVED (Thread Tools above Post #1).
    You can say "Thanks" in your thread to everyone who offered to help you.
    You can also reward them by clicking * "Add Reputation" under their username on the left.
    With Regards, MikeVol.
    Reply With QuoteRegister To Reply
  4. 05-27-2025, 10:23 AM #4
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,072

    Re: Transfer data between workbooks .

    Another Option...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Sintek; 05-27-2025 at 10:32 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  5. 05-28-2025, 12:56 PM #5
    Danilo Flaiban
    Danilo Flaiban is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 365
    Posts
    82

    Re: Transfer data between workbooks .

    Guys... you've all been surgical with the codes!
    There's just one more issue... I just need the date to import the data to be from 2024 to the current year , keeping the idea for zeroes and different values between columns.
    Last edited by Danilo Flaiban; 05-28-2025 at 12:58 PM.
    Reply With QuoteRegister To Reply
  6. 05-28-2025, 05:32 PM #6
    MikeVol
    MikeVol is offline
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    578

    Re: Transfer data between workbooks .

    data to be from 2024 to the current year
    Please try. 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-29-2025, 12:46 AM #7
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: Transfer data between workbooks .

    Here we are
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 05-29-2025, 07:37 AM #8
    Danilo Flaiban
    Danilo Flaiban is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 365
    Posts
    82

    Re: Transfer data between workbooks .

    Thanks very much for the codes.
    Now...The task went very quickly!
    Reply With QuoteRegister To Reply
  9. 05-29-2025, 07:40 AM #9
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: Transfer data between workbooks .

    Good News.
    Thx for the Rep and enjoy Excel
    If you had to go faster, it can be done ...!
    Reply With QuoteRegister To Reply
  10. 05-29-2025, 07:48 AM #10
    MikeVol
    MikeVol is offline
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    578

    Re: Transfer data between workbooks .

    Thx for the Rep+
    With Regards, MikeVol.
    Reply With QuoteRegister To Reply
  11. 05-30-2025, 03:32 AM #11
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,072

    Re: Transfer data between workbooks .

    Apologies for late response...Was attending a conference...
    Just for closure...My amendment...
    Please Login or Register  to view this content.
    Thanks for rep +
    Reply With QuoteRegister To Reply
  12. 05-30-2025, 09:58 PM #12
    Danilo Flaiban
    Danilo Flaiban is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 365
    Posts
    82

    Re: Transfer data between workbooks .

    Thanks a lot, Sintek !!!
    Perfect !!!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Transfer data between workbooks
    By nickytraps in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2019, 01:04 PM
  2. Transfer & confirm data transfer between workbooks
    By fenfool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2015, 01:10 PM
  3. [SOLVED] transfer of data between workbooks
    By flakedew in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-29-2012, 04:08 AM
  4. transfer data to workbooks
    By thair in forum Excel General
    Replies: 5
    Last Post: 04-30-2012, 03:18 PM
  5. Data transfer between workbooks
    By Excel_LEarner13186 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2011, 10:10 PM
  6. transfer data between workbooks
    By rbpd5015 in forum Excel General
    Replies: 1
    Last Post: 12-15-2010, 04:23 PM
  7. Excel 2007 : Data Transfer Across Workbooks.
    By emmarky in forum Excel General
    Replies: 0
    Last Post: 06-10-2009, 04:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1