+ Reply to Thread
Results 1 to 3 of 3

Pulling data from one workbook with multiple tabs to another workbook.

  1. #1
    Registered User
    Join Date
    07-01-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2013
    Posts
    5

    Pulling data from one workbook with multiple tabs to another workbook.

    Hi all,

    Was wondering if this was possible. I have Workbook A and Workbook B. Workbook B has 25 tabs. Each tab has a column with a yes or no answer. Is it possible to pull everything with a "No", along with the values in its corresponding row, and list them all out in workbook A?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Pulling data from one workbook with multiple tabs to another workbook.

    Yes it is possible.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,523

    Re: Pulling data from one workbook with multiple tabs to another workbook.

    A lot of assumptions.
    Column B has the Yes or No and column A has the data
    Try on copies of your workbooks

    Please Login or Register  to view this content.

+ 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. Pulling Rows from other tabs in workbook based on date
    By Pbornho in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2014, 07:50 PM
  2. Pulling data from multiple excel spreadsheets into one workbook
    By lilbamboo in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 05-08-2013, 05:20 PM
  3. Pulling Data From Multiple Different Workouts into One Workbook
    By billevee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 10:22 AM
  4. [SOLVED] Extract data from a workbook with multiple tabs, into a workbook with corresponding tabs
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 11:54 AM
  5. Pulling data from multiple sheets within same workbook
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2009, 05:47 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