+ Reply to Thread
Results 1 to 9 of 9

VB Script to filter data by keywords and copy the data to a sheet based on the Keywords.

  1. #1
    Registered User
    Join Date
    03-05-2020
    Location
    Yeovil
    MS-Off Ver
    Office 365
    Posts
    5

    VB Script to filter data by keywords and copy the data to a sheet based on the Keywords.

    Hi Everyone,

    We have an ICT Helpdesk platform and we have ran a report to show us all help desk tickets from the past 18 months. This has resulted in a good 10k of entries.

    Our next goal would be trying to filter out these entries by topic. Eg, SharePoint, Teams, Word, Excel. Our end goal is to spot trends in tickets so we can issue training and prevent these tickets coming back in.

    So, I have created a sheet called Topic, which has a list of all the subjects we would like to filter out. Then a report sheet, which has all of the tickets. Inside that sheet we have two Columns i need to be able to search. The first one is "Summary" which is column "C" and the second is "Description" Column "D". If one of the search criteria is match i would like to copy that entire row which consists of Creation Date, Created by, Summary and Description, into a corresponding sheet for that particular issue.

    I understand this is probably going to be some VB code required to run this but this a little bit above my skill set in coding.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: VB Script to filter data by keywords and copy the data to a sheet based on the Keyword

    Please attach a short excel example
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    03-05-2020
    Location
    Yeovil
    MS-Off Ver
    Office 365
    Posts
    5

    Re: VB Script to filter data by keywords and copy the data to a sheet based on the Keyword

    Please see attached.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    Quote Originally Posted by hayter_123 View Post
    I understand this is probably going to be some VB code required to run this but this a little bit above my skill set in coding.
    Hi, as it could be easily done just operating manually an Excel basics : an advanced filter …
    Of course an easy VBA procedure may use an advanced filter.

  5. #5
    Registered User
    Join Date
    03-05-2020
    Location
    Yeovil
    MS-Off Ver
    Office 365
    Posts
    5

    Re: VB Script to filter data by keywords and copy the data to a sheet based on the Keyword

    Would an advanced filter be able to move the entries into a corresponding sheet?

    I was hoping to automate the whole process, which is why i thought a VBA Script would be best.

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    According to your initial post the advanced filter can directly copy the data to another place
    like you can see in Excel help or in VBA help …

    As PCI is yet working on this thread, you can wait for his solution.

  7. #7
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: VB Script to filter data by keywords and copy the data to a sheet based on the Keyword

    Is it what you need ??

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    03-05-2020
    Location
    Yeovil
    MS-Off Ver
    Office 365
    Posts
    5

    Re: VB Script to filter data by keywords and copy the data to a sheet based on the Keyword

    So sorry for the late reply PCI. I have been away for a couple of days. This looks good. I will test this later today.

    Thank you so much for spending time taking a look and coming up with this.

  9. #9
    Registered User
    Join Date
    03-05-2020
    Location
    Yeovil
    MS-Off Ver
    Office 365
    Posts
    5

    Re: VB Script to filter data by keywords and copy the data to a sheet based on the Keyword

    PCI - Thank you so much for looking into this for me. It works perfectly. Again thank you for spending your time on this.

+ 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. copying data between keywords to another sheet
    By dgr23 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2018, 11:02 AM
  2. Using VBA to search for keywords in data set and return results in another sheet
    By Rez4ul in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-04-2016, 11:33 PM
  3. [SOLVED] Compile Numerical data based on Keywords in a Sentence
    By phoenixjasper in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2015, 12:32 PM
  4. [SOLVED] VBA looking for multiple keywords and return concatenated keywords, that were found
    By Kpacu007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-10-2014, 06:03 AM
  5. [SOLVED] Search for keywords and copy rows containing keywords to new sheet
    By lenorsk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-15-2013, 06:54 AM
  6. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  7. Copy entire row to new sheet based on keywords
    By jjones3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2010, 12:50 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