I need a simple input box from which to search values in columns A & B. In the example below the values in A & B represent starting and stopping station numbers with the plus symbol separating hundreds from tens... ie. 1+20 is understood as 120 linear ft. 100+00 is understood as 10,000 linear ft.
1| 0+00 1+20
2| 1+21 100+00
3| 2+00 99+00
4| 200+00. 208+00
In the input box I need to be able to enter any desired station number and search each non-empty row to discover if that value is equal to or in-between the values entered in column A & B. So if I enter 55+00 (5,500 linear ft) into the input box it should loop through each row and high light rows
2 & 3 because 5,500 is a value either equal to or between the values for columns A & B on those rows.
There should be a reset feature as well because I will have to check multiple values daily.
12 freelancere byder i gennemsnit $143 på dette job
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hi, I am experienced on Microsoft Access , Excel and VBA, Powerpoint. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
I have many experiences in Excel VBA developing. Of course I know all of Excel and VBA programming. Your task is suitable with me. I'm software engineer with C, C++, C#, SQL, PHP .... Regard your good .