+ Reply to Thread
Results 1 to 2 of 2

pull data from two sheet and paste into master sheet with desired column's only

  1. 08-28-2013, 09:06 AM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    pull data from two sheet and paste into master sheet with desired column's only

    dear expert

    i want vba code to pull data from two sheet in workbook, code has to pull all data from first sheet , then pull data from second sheet and paste some particular column only below first column sheet

    e.g i pull data from two sheet(ONSITE&CCI)

    SHEET-1ONSITE CONTAINS HAVE 57 COLUMN
    SHEET-2 CCI CONTAINS ONLY 19 COLUMN
    FIRST I PULL 57 COLUMN DATA ONCE FINISH MOVE TO SECOND SHEET CCI CONTAINS 19 COLUMN BUT ITS HAS TO PASTE DATA BELOW DATA OF ONSITE TO PARTICULAR ASSIGNED COLUMN'S ONLY BUT COLUMN NAMES IN BOTH SHEET IS TOTALLY DIFFERENT

    IF GET CONFUSION IN MY DESCRITPION PLEASE FIND THE ATTACHMENT
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-13-2014, 03:39 AM #2
    Naveed Raza
    Naveed Raza is offline
    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: pull data from two sheet and paste into master sheet with desired column's only

    have a look to attached file
    Attached Files Attached Files
    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.
    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. Get data from different sheet and paste it in master sheet
    By amar05 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2013, 05:24 PM
  2. backup odbc data pull table from one sheet and copy/paste to another sheet to trend data
    By marabm75 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 03:09 PM
  3. [SOLVED] Comparing sheet to sheet and specific criteria match, pull data from another column
    By Dena in forum Excel General
    Replies: 4
    Last Post: 08-29-2012, 10:32 AM
  4. Copy and paste data from one sheet to a master sheet
    By pauldaddyadams in forum Excel General
    Replies: 10
    Last Post: 06-23-2012, 10:31 AM
  5. Pull data from identical sheets onto master sheet
    By veritas1 in forum Excel General
    Replies: 2
    Last Post: 08-18-2011, 05:45 AM

Tags for this Thread

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