+ Reply to Thread
Results 1 to 1 of 1

Associate Data Entry with Other Data

  1. #1
    Registered User
    Join Date
    06-04-2008
    Posts
    1

    Associate Data Entry with Other Data

    Hi. This is, i think, a tough one. It's a little bit hard to explain so i will be as clear as i can. Ok so there is the data. Please refer to this image. The question will follow.

    http://www.mellostudios.com/tempo/ex...ions_excel.gif

    I have an excel sheet with information about music.They're is 798 entries.

    I have the info about the ARTIST, the TITLE and i have also the IMAGE path information. The thing is, the infos on the ARTIST and the TITLE columns are ok and they are sorted the right way. I can't change that order, absolutly not. But in the @IMAGE column I have a list of image path that correspond to the songs on the 2 first columns. This column is all mixed up and unsorted.

    But the filename may contain one word or two in the one of the 2 other columns. Sometimes the filename of the image contains the title, sometimes the artist, sometimes both and sometimes none of them.

    For example, in the second row, in the IMAGE column, i have the filename "Nordbanhof.jpeg". I am pretty sure that i will found this info somewhere in the TITLE column.

    My question is : is there a way inside or outside of excel to quickly assisgn the most possible entries of the IMAGE column to their correspondant row in the 2 other columns ?

    I know it's a little bit hard to explain, but i am sure there is way. Maybe in excel or maybe in an external software. The thing is i don't want to manualy assing the right filename to the right entry..sure you guess what kind of job it involves...

    thanks
    Attached Images Attached Images

+ 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. Automatically hide rows upon data entry
    By aquatrojan in forum Excel General
    Replies: 3
    Last Post: 11-25-2015, 11:57 AM
  2. Data entry/ forms
    By sukhi_01 in forum Excel General
    Replies: 4
    Last Post: 05-14-2008, 08:32 AM
  3. Replies: 2
    Last Post: 02-14-2008, 05:02 PM
  4. Selecting only cells that require data entry
    By GunRights4US in forum Excel General
    Replies: 2
    Last Post: 01-03-2008, 06:27 PM
  5. Data Entry thru a Macro
    By carlos.peres in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-24-2007, 02:27 AM

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