I have several macros written to update information in a spreadsheet based on
an entry into a input box. I need to change these macros to instead look at
a column of numbers in another file and find each number in my spreadsheet
and update. The following is an example of one of the macros:

Dim equipNum As String
Do
equipNum = InputBox("Scan in the Equipment Number. Type Done to Exit")

Cells.Find(What:=equipNum, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(0, 3).Select
ActiveCell.FormulaR1C1 = "Y"

Loop Until equipNum = "Done"
Range("A1").Select

I am using Excel 2003 and only have a moderate grasp on macros. Any help
would be greatly appreciated!

Thanks,
Holly