Results 1 to 10 of 10

Thread: i want VBA to display values greater than or equal to the given number

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    Your second file is considerably different from your first, especially regarding there being multiple skills and experience in single cells.
    Hiding/unhiding rows with code doesn't work well with autofilters; to get unambiguous results it needs to be autofilter only, or something else without autofilter.


    Quote Originally Posted by supraman View Post
    is there any other method so that i can apply it over my every possible aspect
    The main problem lies with the unconventional data layout. To cater easily for many aspects requires a radical change of data layout. Having said that, attached has a bespoke solution for your new scenario.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

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