Hello!
I am trying to create a sub that creates an inputbox and then takes the information from this and searches through a column for that value. If the value is found then I would like to change a value of a cell in the same row.
For example, if you enter the value of 1000 into the inputbox then go search B1:B1500 for that value. If you find that in B250 then go change the value of H250 to "500-00-01". I know I can use the Do While loop (although For Next might work as well) but I can't figure out exactly how to shift over the cell. Here is what I ha
Thanks in advance everyone!
Bookmarks