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