The look up tool is just a button I have created to process the macro. I
just can't get it to look through multiple sheets.

Currently on sheet one I have a chart that looks like this:

Updated Successfully
IMEI # 351609012359835 "Click to Update" (Button)
Receipt # 611049



On sheet two I have all of the serial numbers listed and further
details:

Brand Model IMEI Receipt #
Ericsson T62U 10124716931015
Ericsson T237 10273003777258 611087
Ericsson T237 10273003777290 611095
Ericsson W6001 357446000798235
Ericsson Z520A 351609011849133 611029
Ericsson Z520A 351609011846626
Ericsson Z520A 351609011147819 611089
Ericsson Z520A 351609012359835 611049


I want to be able to put the receipt number in that goes with the
serial number even if the serial number is on a different sheet.


--
creese
------------------------------------------------------------------------
creese's Profile: http://www.excelforum.com/member.php...o&userid=35508
View this thread: http://www.excelforum.com/showthread...hreadid=554590