+ Reply to Thread
Results 1 to 10 of 10

Copy and Paste data through VBA

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Copy and Paste data through VBA

    hello friends..........

    today i am facing a problem..........

    i am upload a Test file.........

    In this file I have generate 10 Master sheets i.e. Master (2), Master (3), Master (4), Master (5)…………….. Master (11) it may be 10 or may be 1000
    I Want a code which will copy the data of Col D8 from Data Sheet and paste it in Master (2)’s D5 col….....

    For example:- when i click on Commandbutton3 which is exist in Summary sheet
    it will Copy the Data from Data Sheet’s Col-D8 and paste it in Master (2)’s D5 col.
    Copy the Data from Data Sheet’s Col-D9 and paste it in Master (3)’s D5 col.
    Copy the Data from Data Sheet’s Col-D10 and paste it in Master (4)’s D5 col
    It will repeat these steps until found Last Master (…….) sheet but do not make any changes the Master sheet because this is Master Sheet and it should be blank

    That’s it
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Copy and Paste data through VBA

    try below code

    Please Login or Register  to view this content.
    Regards,
    MohanS


    "Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi

    You can simply say thanks by clicking "*Add Reputation" icon

  3. #3
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Copy and Paste data through VBA

    sir its working but it is not feed the data in Master (2) to Master (6)
    i am again uploading a Test1 file.........please see and fix it if possible
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Copy and Paste data through VBA

    working here
    see attached file
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Copy and Paste data through VBA

    it is working on previous sheet and not working on Test1.....please see what is the problem

  6. #6
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Copy and Paste data through VBA

    upload xls or xlsx file
    test1.xlsm not downloading on my PC

  7. #7
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Copy and Paste data through VBA

    I uploaded a xlsx file please see
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Copy and Paste data through VBA

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Copy and Paste data through VBA

    Thankyou very much sir it is working..........Thankyou

  10. #10
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Copy and Paste data through VBA

    your welcome

    Please Mark Solved your thread

+ 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. [SOLVED] Copy/paste data using checkbox-clear when unchckd & multiple selections paste in next cell
    By Staceymcw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2015, 12:09 AM
  2. copy formula and paste for new data added and autofill.....and paste special values
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2014, 07:40 AM
  3. Replies: 6
    Last Post: 03-26-2014, 11:40 PM
  4. Enter data, copy formulas, copy values, paste data, delete data
    By alf40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2013, 07:23 PM
  5. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  6. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  7. Replies: 2
    Last Post: 02-22-2011, 02:07 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