+ Reply to Thread
Results 1 to 1 of 1

Help with Pulling Data from Multiple sheets using Indirect Formual.

  1. #1
    Registered User
    Join Date
    01-21-2018
    Location
    Northampton, England
    MS-Off Ver
    2010
    Posts
    50

    Help with Pulling Data from Multiple sheets using Indirect Formual.

    Afternoon all,

    This is like a previous post but it was already solved so looking for an amendment to it to adjust to new demand.

    I'm trying to use Indirect to pull data from multiple sheets into one, however i need it to skip the data if there is in the other column.

    So for example if Column B is the data to pull, if A4 has a value then it wont pull the data from there and will skip to A5 that has no value and pull the data from B5.

    This needs to be continue as the sheets have data from Row 4 to Row 300/350. but only up to 10 data values needing to be pulled.
    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. [SOLVED] Help with Pulling Data from Multiple sheets using Indirect Formual.
    By Hyperion1571 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-12-2019, 08:03 AM
  2. Pulling data from multiple sheets
    By accelerate7 in forum Excel General
    Replies: 2
    Last Post: 03-20-2017, 12:34 AM
  3. Replies: 3
    Last Post: 09-23-2014, 04:48 PM
  4. Pulling Data From Multiple Workbooks/Multiple Sheets into one Master Book
    By LSUARefugee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2013, 12:37 PM
  5. Replies: 7
    Last Post: 03-09-2012, 01:29 AM
  6. Pulling cell data from multiple sheets
    By Stkbm in forum Excel General
    Replies: 2
    Last Post: 02-03-2009, 03:17 PM
  7. Replies: 4
    Last Post: 08-17-2006, 01:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1