I have a database at work which includes the account numbers of
customers.

In an Excel spreadsheet I have produced a job card for use in the
workshop.

I would like to be able to run a macro that takes details like name and
address etc and puts them in appropriate cells.

I would like it to do this by searching for an account number and then
copying the required data.
I can get it to run but only for an account number I put in as an
example.

any help would be appreciated, particularly if it is explained simply.

thanks

John


--
justjohn
------------------------------------------------------------------------
justjohn's Profile: http://www.excelforum.com/member.php...o&userid=30663
View this thread: http://www.excelforum.com/showthread...hreadid=503672