Results 1 to 2 of 2

Thread: Looking to find a way to extract email addresses from imported data which changes on

  1. #1
    Neophyte Sliepner's Avatar
    Join Date
    Apr 2021
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Smile Looking to find a way to extract email addresses from imported data which changes on



    Register for a FREE account, and/
    or Log in to avoid these ads!

    On a daily basis we get an information dump about upcoming rota movements. I have to extract the email addresses of those individuals who have not as yet had the relevant training – this was straightforward enough, I have an “ISBLANK” (Column L)to combine the 2 columns of addresses (Cols J&K) and then a pivot table to give me the emails and filter out those who had done the training already (Column H).

    However, was then informed that department personnel from either Core or SAFCORE do not have to do the training. Can anyone suggest how best to achieve this? Is there a way without having to select the relevant filters every time the base information is pasted? Either VBA or another pivot table? So that when I am not here, anyone will be able to do the copy/paste and extract without having to do anything else?
    Any help would be greatly appreciated. Attached, the info dump structure. Thanks.
    Attached Files Attached Files

  2. #2
    Neophyte Sliepner's Avatar
    Join Date
    Apr 2021
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Talking Solved

    just realised I could do multiple Filters in the Pivot table.
    Last edited by Sliepner; 2021-04-24 at 08:45 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •