+ Reply to Thread
Results 1 to 6 of 6

Extracting specific data from lists and copying to another location

  1. 08-24-2012, 02:09 PM #1
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Extracting specific data from lists and copying to another location

    Hi all. Back again with another irritating problem.

    I have lots of different datasets, which all fall into this basic pattern. I want to sort the data by key criteria contained in more than one column of the data and copy the appropriate values in another column to the same (or preferably another) sheet. I struggle to find the words, but the general form of the data and the desired result are shown in the attached sample...

    Here's hoping...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-24-2012, 07:01 PM #2
    watersev is offline
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Extracting specific data from lists and copying to another location

    hi Glenn Kennedy, option to make it, please check attachment, press Run button
    Attached Files Attached Files
    Last edited by watersev; 08-24-2012 at 07:11 PM.
    Reply With QuoteRegister To Reply
  3. 08-25-2012, 02:16 AM #3
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Extracting specific data from lists and copying to another location

    Watersev,

    It's still early morning here & I've just looked over your elegant solution. It's perfect. Many, many thanks!!
    Reply With QuoteRegister To Reply
  4. 08-27-2012, 06:22 AM #4
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Extracting specific data from lists and copying to another location

    There's still a bit of a problem with this. see the comments on sheets 5 & 10
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-27-2012, 07:34 AM #5
    watersev is offline
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Extracting specific data from lists and copying to another location

    you are right, there was an error on officer's part in thecode, the code has been updated, please find attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-27-2012, 09:50 AM #6
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Extracting specific data from lists and copying to another location

    That did the trick! Many thanks, Watersev!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1