Excel Macro

[sabavno]

Hi,

I am looking for the hints on how to write the following macro in Excel.

The is a huge spreadsheet containing the serial numbers along with other information. I want to prompt the user for the Serial Number, then make the cell with the matched serial number active, look up the information in the next cell on the same raw and calculate the value.

Any help would be greatly appreciated.

Thanks.

 

[SkipVought]

Hi,

How 'bout using the AutoFilter, where the user can select the Serial Number and see the entire row.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884