Hi -

I was wondering if I could gain some assistance with a project that I have been tasked to work on. I am a newbie at programming and really strapped for time.

We have a lot of assets that get moved around in my office and I have created a Excel spreadsheet to "check in" these assets when they are returned. The information I need to capture in this Excel spreadsheet is the "Asset Tag", "Name of Asset", "Serial Number", and "Model". Currently, we input all of this information by hand. I would like to be able to just type the "Asset Tag" and have Excel populate the rest of the data from a database table I have created in SQL Server 2005 based on the unique "Asset Tag".

For example:

If I type in 123456 (which is an Asset #) in A2 in MS Excel, I would like SQL to return the rest of the asset’s data located in a table in my SQL database (name, serial #, model #) in B2, C2, and D2 based on that “Asset #” (which is the primary key in my SQL table that I created) that I typed in A2.

Is this possible? Can someone please point me in the right direction?

Thanks in advance.