+ Reply to Thread
Results 1 to 2 of 2

pulling bits of data and putting it into a specific cell on another sheet

  1. #1
    Registered User
    Join Date
    12-07-2015
    Location
    usa
    MS-Off Ver
    10
    Posts
    10

    pulling bits of data and putting it into a specific cell on another sheet

    I want to combine data from several worksheets onto one 'master' worksheet automatically. The 'topics' in each worksheet are mostly the same but not identical. An example of what I want to do is below. How do I make excel do this? There are over 40,000 lines total when all worksheets are added together.


    worksheet a:
    taco tuesday 598
    glass half full 61
    empty container 36
    lazy susan 1888
    snazzy betty 89

    worksheet b:
    empty container 877
    lazy susan 941
    taco tuesday 866
    glass half full 799
    excited elephant 5

    worksheet c:
    lazy susan 2500
    taco tuesday 1782
    glass half full 1900
    empty container 645
    snazzy betty 966

    I want to end up with a master worksheet that looks like this and does it automatically: (note: imagine that the name and then each number are in its own separate column, this forum removes extra spaces)
    name a b c
    lazy susan 1888 941 2500
    glass half full 61 799 1900
    empty container 36 877 645
    taco Tuesday 598 866 1782
    snazzy betty 89 empty 966
    excited elephant empty empty 5

  2. #2
    Registered User
    Join Date
    10-28-2015
    Location
    Philippines
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    10

    Re: pulling bits of data and putting it into a specific cell on another sheet

    Please Try this.. I hope it helps
    Attached Files Attached Files

+ 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. Replies: 3
    Last Post: 04-02-2013, 07:11 PM
  2. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  3. Code to pulling specific data from a sheet
    By pnaquin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-26-2011, 05:32 PM
  4. [SOLVED] Pulling (or putting) data
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2010, 06:56 PM
  5. Replies: 3
    Last Post: 10-05-2010, 11:19 AM
  6. Pulling data from a sheet into Word in a specific order
    By schallpattern in forum Excel General
    Replies: 0
    Last Post: 06-09-2009, 03:29 PM
  7. Replies: 4
    Last Post: 03-04-2005, 03:06 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