+ Reply to Thread
Results 1 to 9 of 9

Extract Data from one worksheet to another ONLY if condition is met

  1. #1
    Registered User
    Join Date
    11-13-2020
    Location
    Olive Branch, Mississippi, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Extract Data from one worksheet to another ONLY if condition is met

    I use Office 365. I have used Excel for years, but this one has me stumped. I have gone at it different ways and keep hanging up.

    Can you help?

    I'm trying to pull data from Sheet2, cells starting in D2 through F2 on down, and put it in Sheet1 starting in J6 through L6
    ONLY IF ADD is in column A in Sheet2

    I'm stuck.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    241

    Re: Extract Data from one worksheet to another ONLY if condition is met

    Hi juliewyatt75,
    Here is my solution. I had to add some "helpers" on sheet 2. You can hide these. There may be better solutions but this does work as long as you drag the formulas down at least as long as your data.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-13-2020
    Location
    Olive Branch, Mississippi, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Extract Data from one worksheet to another ONLY if condition is met

    I appreciate your help, but it isn't pulling the information with Add in column A on Sheet2.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Extract Data from one worksheet to another ONLY if condition is met

    Squeaky, you have the correct solution but there is a typo in your formula:

    Change
    =@IF(Sheet2!$X1="","",INDEX(Sheet2!$D:$F,Sheet1!$X1,COLUMN()-9))
    To
    =@IF(Sheet2!$X1="","",INDEX(Sheet2!$D:$F,Sheet2!$X1,COLUMN()-9))

  5. #5
    Registered User
    Join Date
    11-13-2020
    Location
    Olive Branch, Mississippi, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Extract Data from one worksheet to another ONLY if condition is met

    That worked perfectly! Thank you so much Squeaky & 6StringJazzer! Have a beautiful weekend!

  6. #6
    Registered User
    Join Date
    11-13-2020
    Location
    Olive Branch, Mississippi, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Extract Data from one worksheet to another ONLY if condition is met

    It worked in that sample worksheet, but then when I tried it in my actual worksheet, I get a circular reference error. HELP

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Extract Data from one worksheet to another ONLY if condition is met

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  8. #8
    Registered User
    Join Date
    11-13-2020
    Location
    Olive Branch, Mississippi, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Extract Data from one worksheet to another ONLY if condition is met

    Here it is. The tabs on the right are what I got from the example sent back. Why is it that I use the same formula, it gives me a circular reference?
    Manual Tracking was Sheet1 and Widget was Sheet2.
    Attached Files Attached Files
    Last edited by juliewyatt75; 11-13-2020 at 07:04 PM.

  9. #9
    Registered User
    Join Date
    11-13-2020
    Location
    Olive Branch, Mississippi, USA
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Extract Data from one worksheet to another ONLY if condition is met

    I figured out how to fix it. Thank you both for your help!

+ 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] Extract data from one Column if Condition is in 2 Columns
    By ionelz in forum Excel General
    Replies: 2
    Last Post: 10-20-2020, 05:56 AM
  2. [SOLVED] Extract Data, one condition !
    By ionelz in forum Excel General
    Replies: 10
    Last Post: 02-01-2020, 12:43 PM
  3. Extract Data from Range with Condition
    By ionelz in forum Excel General
    Replies: 5
    Last Post: 09-04-2019, 11:14 AM
  4. [SOLVED] Basing on the condition, needs to extract the data
    By sateesh konduru in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-10-2016, 02:38 PM
  5. [SOLVED] Need Help to Extract data from required tab as per condition
    By Naveed Raza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 01:54 AM
  6. [SOLVED] Extract data that meets specific condition from large raw data
    By tekobayashi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2012, 03:50 AM
  7. [SOLVED] Extract data based upon Yes/No condition
    By dramadog in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2012, 05:15 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