I am trying to write some code that will utilize an input box to find a value. At that point I want to run a macro that will reference the cell rows of all values that equal the input box value. I have sorted this column in ascending order so that similiar value will be together.
I believe the code I'm looking will look similar to this but I don't know how prepare the range.
For a = 1st cell row # = InputBox to Last Cell row # = InputBox
So say I have Finance in rows 2-5, HR in rows 6-9 and Sales in rows 10-15. If I entered HR in the input I would want to reference cells 6-9.
e.g. For a = 6 to 9
Can someone please help me with this problem?