+ Reply to Thread
Results 1 to 3 of 3

Macro / VBA to Copy data from one excel and paste in another

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    India
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    41

    Macro / VBA to Copy data from one excel and paste in another

    Hi! I need some help with a code which picks data from one excel file and pastes it in another. Data range is B2 to E28. Format in both the excel files will remain same.
    Name of two workbooks are Source File and Destination File.
    I want to copy data from Source file to Destination file. I will provide a Macro button so that on one click the data gets copied.
    Could someone please help me with this. Thank you very much!!
    PS : I only know basic excel and do not know how to write a macro / VB codes

    Best Regards,
    Rashmi
    Last edited by RashmiD2930; 08-31-2020 at 08:02 AM. Reason: Changing based on excels shared

  2. #2
    Registered User
    Join Date
    07-29-2020
    Location
    India
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    41

    Re: Macro / VBA to Copy data from one excel and paste in another

    I am sharing sample for better understanding on the requirement. Thankyou!
    Regards,
    Rashmi
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-29-2020
    Location
    India
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    41

    Re: Macro / VBA to Copy data from one excel and paste in another

    Hi, Can someone please help me with this...

    Regards,
    Rashmi

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a Macro to copy data from Excel and paste data to webpage
    By Bharat kumar reddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2016, 10:20 PM
  2. Macro to copy data from website and paste into excel
    By RedLeaderX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2015, 09:04 PM
  3. Macro to copy data from website and paste to Excel
    By RedLeaderX in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2015, 03:52 PM
  4. Excel Macro to copy paste ecel data to website
    By muthu_1289 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 11:32 AM
  5. need excel 2007 macro for copy data from excel and paste it in SAP screen (f-28)
    By jprakash in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 08:45 AM
  6. Replies: 1
    Last Post: 02-18-2013, 11:36 AM
  7. MS Excel 2003 macro to copy paste data in different sheets based on certain criteria
    By bhaktprahlad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2010, 06:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1