I'm using VBA for Excel and would like to do the following:
1) in sheet1, search for a value which is given in a specific cell location
on sheet2.
2) when i find that value in sheet1, i want to insert in the cell
immediately to the right of the active cell a formula which includes a
reference to a fixed cell location from sheet2
3) then i want to do the same search again in sheet1, this time using the
cell immediately below the cell in sheet2 used in the first search.
4) i want to continue this pattern until the cell on sheet2 below the one
used for the previous search is empty.
Thanks in advance for any help.
1) in sheet1, search for a value which is given in a specific cell location
on sheet2.
2) when i find that value in sheet1, i want to insert in the cell
immediately to the right of the active cell a formula which includes a
reference to a fixed cell location from sheet2
3) then i want to do the same search again in sheet1, this time using the
cell immediately below the cell in sheet2 used in the first search.
4) i want to continue this pattern until the cell on sheet2 below the one
used for the previous search is empty.
Thanks in advance for any help.