Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Page 3 of 4 FirstFirst 1 2 3 4 LastLast
Results 21 to 30 of 32

Thread: $20 criteria based cell value mining

  1. #21
    Join Date
    27th May 2011
    Posts
    57

    Re: $20 criteria based cell value mining

    Hi Wigi, looks good but I keep getting an error message. after running the test, sColumnName =" ", i.e no value, and the error message shows: The column name for the selected cell (X31) is empty.
    it seems to to pick up the cell value well i.e the rCell_selection fine, but not the column name. Bearing in mind there are other tables all over the sheet both before and after.

  2. #22
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,325

    Re: $20 criteria based cell value mining

    Please add a small testfile such that I can reproduce it.
    Also, please provide the steps that you do when the error occurs.
    Regards,

    Wigi

    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  3. #23
    Join Date
    27th May 2011
    Posts
    57

    Re: $20 criteria based cell value mining

    Quote Originally Posted by Wigi View Post
    Please add a small testfile such that I can reproduce it.
    Also, please provide the steps that you do when the error occurs.
    Hi Wigi,

    This is the situation with the table 2, as mentioned there are several on one page but only interested in the one highlighted yellow.Capture6.jpg
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  4. #24
    Join Date
    27th May 2011
    Posts
    57

    Re: $20 criteria based cell value mining

    Here is an example workbook the macro would open and highlight cells. file name is same as the link in the example file as an example.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  5. #25
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,325

    Re: $20 criteria based cell value mining

    Hello,

    I solved it. Your screenshot in post #16 was misleading/incorrect.
    We have to do lookup the name in the row heading in the table on the other sheet, not the name in the column heading.
    Anyway, here is the updated coding in attached file.

    Also, I had to make changes to your file names (\ and also xlsx instead of xls).

    After these changes it works flawlessly.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Regards,

    Wigi

    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  6. #26
    Join Date
    27th May 2011
    Posts
    57

    Re: $20 criteria based cell value mining

    Hey Wigi, Sorry actually it was correct. Just the test file I just sent you was incorrect. it is actually looking up the column names. but still unsure how to do this.

  7. #27
    Join Date
    27th May 2011
    Posts
    57

    Re: $20 criteria based cell value mining

    See correct column naming convention.
    So on selection the tables column name and left row reference is used as reference to select the correct link in the other sheet to open, an the vlookup is performed on the row reference.

    hope this helps!
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  8. #28
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,325

    Re: $20 criteria based cell value mining

    Newest version of the file attached
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Regards,

    Wigi

    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  9. #29
    Join Date
    27th May 2011
    Posts
    57

    Re: $20 criteria based cell value mining

    Captureerror1.JPG
    Ran the code but somethings stopping it from working at all

  10. #30
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,325

    Re: $20 criteria based cell value mining

    This means that in the first column of the table (with address C2:C8) we cannot find 'A'.
    This A is the column heading of the cell that you select when running the small macro.
    Regards,

    Wigi

    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Automatic Data Mining and Word Counts
    By starkman in forum Excel General
    Replies: 1
    Last Post: July 19th, 2011, 02:38
  2. Re: Text Mining in large database
    By apassala in forum Excel General
    Replies: 1
    Last Post: October 10th, 2010, 21:35
  3. Data Mining Multiple Workbooks
    By matrix01 in forum Excel General
    Replies: 4
    Last Post: January 10th, 2008, 06:07
  4. Text Mining in large database
    By JoshuaJ in forum Excel General
    Replies: 2
    Last Post: March 29th, 2006, 08:31

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
  •  
porno