Need Help! Macro or VBS?

S

Shane

Hey gang....

I have a large worksheet that I need to go through and was looking for
programming help.

Basically, I need to have Excel see if there is an entry in a cell. If there
is, I need Excel to place that entry in another cell as well.

If Excel sees a value in a cell along a row, I need it to place that value
in a cell down a corresponding column.

For instance, if there is a value in cell C1 (1st ROW, three OVER) - I need
Excell to place that value in cell A3 (1st COLUMN, three DOWN). And so on....

Any suggestions?
 
D

Don Guillett

try this

Sub findandoffset()
mv = "a"
On Error GoTo notfound
x = Columns(3).Find(mv).Address
MsgBox x
Range(x).Offset(3, -2) = mv
End
notfound:
MsgBox "not found"
End Sub
 
Top