I was wonding if someone can help me with a macro problem that has been driving me crazy. What i want to do is to have excel search for a number that i specify and input a certain number adjacent to it. So...
i would specify excel to search number 47 and have it input 28 next to it, and continue to do this for a list of numbers.
I need it to search the cell value of A1804 because it will change often and need it to continue the process to A1805,A1806, .....and so on. The macro i created will only search for 47 and will not move to the next line. I know this is a bit confusing and difficult to understand, so any help you can give would be great.
ActiveCell.FormulaR1C1 = "47"
Cells.Find(What:="47", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _