The answer is YES. You probably have a column in the database when a tool is
assigned to a job and when it is returned. A macro can also ad an assign
mark into the database. Excel VBA would need to open the database, find an
tool not asigned and then download the access number of the tool, and finally
mark the database that the tool has been assigned. You probably want to also
to include in the database when it ws assigned and which job is using the
tool. IYou can also add a link in both directions from access to excel and
ecel to access.

"Bob H" wrote:

I have a database of tools, many different types, and we have a
spreadsheet which lists certain tools which are required for a job.

The database lists every tool we have and all have an asset number.
So from the spreadsheet; if it says that 2 35ton hydraulic jacks are
needed, then I would like to be able to have a link which will go to the
database and show or list the 2 jacks we will use; each with their own
asset label.

Is this possible?
Thanks