+ Reply to Thread
Results 1 to 7 of 7

How to extract data from one worksheet into another

  1. #1
    Registered User
    Join Date
    06-23-2021
    Location
    Cheshire
    MS-Off Ver
    Version 2105 of O365
    Posts
    3

    Smile How to extract data from one worksheet into another

    My objective is to pull the data from the STATUS column in Worksheet 2, as per the pic below...

    Pic 1.JPG

    And to have that data shown in the VERIFICATION cells of Worksheet 1 (shown in green), by matching against the corresponding email address. So for example, in the case of DAVE JONES, I would want the VERIFICATION column of Worksheet 1 to display 'Invalid'.

    Capture2.JPG

    To be honest im at a loss as to which function to even begin with so would appreciate help on which function to use and the function calculation itself to get me started. Many thanks in advance.
    Attached Files Attached Files
    Last edited by Mathaniel; 06-23-2021 at 03:44 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,651

    Re: How to extract data from one worksheet into another

    You have posted in the Outlook section - was this a mistake? I can move the thread if needs be.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    06-23-2021
    Location
    Cheshire
    MS-Off Ver
    Version 2105 of O365
    Posts
    3

    Re: How to extract data from one worksheet into another

    Ahhh yes please - no idea why i did that lol
    Last edited by AliGW; 06-23-2021 at 03:43 AM. Reason: PLEASE don't quote unnecessarily!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,651

    Re: How to extract data from one worksheet into another

    Done.

    There are instructions at the top of the page explaining how to attach your sample workbook.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

    Re: How to extract data from one worksheet into another

    In WS1, H2, copied down:

    =IFERROR(VLOOKUP(E3,'Worksheet 2'!B:C,2,FALSE),"")
    Attached Files Attached Files
    Glenn



  6. #6
    Registered User
    Join Date
    06-23-2021
    Location
    Cheshire
    MS-Off Ver
    Version 2105 of O365
    Posts
    3

    Re: How to extract data from one worksheet into another

    Glenn thanks for the reply - I've put this into my data and what i didnt appreciate was that Worksheet 1 and Worksheet 2 are ordered differently and have different quantities of email addresses. I.e. there is no way to put them in a comparable order.

    Is there a way to address this and for say excel to look at all the email addresses and appropriate them into Worksheet 1?

    Thanks

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,104

    Re: How to extract data from one worksheet into another

    Show me in a new sample exactly where/how it DOES NOT work.

+ 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. Sub: extract data from one excel worksheet to another worksheet
    By raja1964 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2019, 01:28 PM
  2. Replies: 1
    Last Post: 06-24-2018, 06:02 PM
  3. Replies: 11
    Last Post: 12-04-2012, 02:56 AM
  4. Replies: 0
    Last Post: 07-09-2012, 03:10 PM
  5. Using a column of data from 1 worksheet to extract data from another worksheet
    By banderson@nwws.biz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 12:35 PM
  6. [SOLVED] Extract data from one Worksheet to another
    By extract data fr. one worksheet to anothe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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