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

[supraman]

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.


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.

Hay Man,
Greetings of the day.

The script is absolutely fine but as per my original data I need to replace SL no with Emp Id and In column D there will be many blanks for Skills.

let me tell you i have another script with the file which help me to clear all the old data from A4:F4 till lastrow and paste the new data along with Headers (A4:F4) from another file which can increase the row numbers only. Now problem is when i tried to run the script on my original Data where data range in column is same but volume can varies (20K rows approx) giving me a Run time error on line "aa = UCase(Left(xx(j), lastOpenBracket - 1))" in the script with a error msg "invalid procedure call or argument".

Can you please help me on this.
Or is it possible to create some code which can marge TB1 and TB2 value and provide a search result combined, so that if i put "Core java" in TB1 search until i am not giving any numeric value in TB2 it will not work, similarly if i change Tb1 search from "Core java" to some other name for the same value of TB2 or vise versa change in TB2 Value, it need to display the TB1 search with the similar or greater Value of TB2 from D column.

If possible can you please explain me the entire code as i haven't understood few lines from the script. i have attached my file where i have another script for clear and paste the required data, Original file is more than 10 MB hence unable to attach that file, you can find the problem every time once you replace old data with a new one.


My deadline for the task is about to end. if possible can you please short this issue at the earliest.Or can we connect over a call or sharing the screen so that i can narrate you my need on real time.


Support required badly.
Subhankar
+91-7618788845.
Awaiting for your response.