+ Reply to Thread
Results 1 to 7 of 7

How to transfer specific row of data from multiple workbooks to master workbook using VBA

  1. #1
    Registered User
    Join Date
    01-02-2012
    Location
    Karnatak, India
    MS-Off Ver
    Excel 2010
    Posts
    34

    How to transfer specific row of data from multiple workbooks to master workbook using VBA

    Hello,

    I have a VBA code which transfers mutiple rows of data from multiple workbooks to master workbook.

    Please Login or Register  to view this content.

    But I am looking out for a VBA code which should transfer only a specific row of data from multiple workbooks to master workbook using VBA. I want only the data which is present in ROW 3 to be transferred to master workbook.

    I have attached 4 samples of spread sheet for your reference. Can someone please HELP me on this!
    Last edited by rajeshntiwari; 10-07-2014 at 05:41 AM.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: How to transfer specific row of data from multiple workbooks to master workbook using

    Please correct your post and add Code Tag to your Code first
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    01-02-2012
    Location
    Karnatak, India
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: How to transfer specific row of data from multiple workbooks to master workbook using

    Done, I have tagged it!

  4. #4
    Registered User
    Join Date
    01-02-2012
    Location
    Karnatak, India
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: How to transfer specific row of data from multiple workbooks to master workbook using

    Done, I have tagged it!

  5. #5
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: How to transfer specific row of data from multiple workbooks to master workbook using

    Quote Originally Posted by rajeshntiwari View Post
    Done, I have tagged it!
    Give me time tomorrow i will provide.

  6. #6
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: How to transfer specific row of data from multiple workbooks to master workbook using

    Hi Rajesh

    Steps to Use:
    1. Paste All Employee's Workbook at one Path
    2. Open Master Workbook File and paste that file Path in Master Workbook in B1 Cell
    3. Next Click on Button.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-02-2012
    Location
    Karnatak, India
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: How to transfer specific row of data from multiple workbooks to master workbook using

    Thanks buddy! Your are awesome I have added reputation to you!

+ 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] Transfer Data from Multiple SharePoint Workbooks into Master Workbook Automatically
    By bjnockle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2014, 10:37 PM
  2. VBA to consolidate specific data from multiple workbooks to a master workbook
    By Blastaway12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2014, 04:39 PM
  3. Replies: 12
    Last Post: 04-18-2014, 09:05 AM
  4. Export/ Retrieve specific data from multiple workbooks and Import into Master workbook
    By SerenitynWisdom in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-29-2013, 10:41 PM
  5. Help on macro to automatic transfer of data from multiple workbooks to master wkbk
    By ryuytsuken in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2013, 06:16 PM

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