Results 1 to 7 of 7

Search 'String' and tag accordingly using 'String table'

Threaded View

tms12 Search 'String' and tag... 04-11-2011, 01:05 PM
mrice Re: Sreach 'String' and tag... 04-11-2011, 02:00 PM
tms12 Re: Search 'String' and tag... 04-11-2011, 02:55 PM
mrice Re: Search 'String' and tag... 04-11-2011, 03:03 PM
tms12 Re: Search 'String' and tag... 04-12-2011, 12:00 PM
mrice Re: Search 'String' and tag... 04-12-2011, 05:07 PM
tms12 Re: Search 'String' and tag... 04-15-2011, 02:10 PM
  1. #1
    Registered User
    Join Date
    04-11-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    10

    Search 'String' and tag accordingly using 'String table'

    Search 'String' and tag accordingly using 'String table'
    Hi everyone. First of all it’s a great forum and has been very helpful for my excel work. I am not that savvy with excel and got the following situation/s and any help/guidance would be highly appreciated.

    Back ground:
    I have to go through some cost items every month and sort them accordingly. I get the data dump (raw data tab on the attachment) and I need to tag them based on the description. I go through them by hand (about 400 line items) every month and very tedious and time consuming.

    Problem:
    Now I am looking for a way to automate them (as much as possible) by using a “string search’ table. My idea is that it will search the ‘description’ column and based on the ‘s-tabs’ table and once a string is found then it will retuen the data from first row of that column
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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