software

I'm trying to figure out what the formula would be to create an auto quot;pastequot;
of information on a spreadsheet. Example: on an inventory spreadsheet I use
a bar code scanner to record products we receive, when I scan that product a
part number will appear. I want to create a formula (if possible) to
automatically paste the description of that part number in the column next to
it. Can this be done and if so...HOW? Any help would be greatly appreciated!

Do you have a list of the bar code info and the description? If so, you
can use VLOOKUP to get what you want.

quot;Kelly Cquot; gt; wrote in message
...
gt; I'm trying to figure out what the formula would be to create an auto
gt; quot;pastequot;
gt; of information on a spreadsheet. Example: on an inventory spreadsheet I
gt; use
gt; a bar code scanner to record products we receive, when I scan that product
gt; a
gt; part number will appear. I want to create a formula (if possible) to
gt; automatically paste the description of that part number in the column next
gt; to
gt; it. Can this be done and if so...HOW? Any help would be greatly
gt; appreciated!
Provided you have a master list of part numbers and descriptions somewhere
you should be able to use VLOOKUP to get the description for an input part
number

Regards

Trevorquot;Kelly Cquot; gt; wrote in message
...
gt; I'm trying to figure out what the formula would be to create an auto
gt; quot;pastequot;
gt; of information on a spreadsheet. Example: on an inventory spreadsheet I
gt; use
gt; a bar code scanner to record products we receive, when I scan that product
gt; a
gt; part number will appear. I want to create a formula (if possible) to
gt; automatically paste the description of that part number in the column next
gt; to
gt; it. Can this be done and if so...HOW? Any help would be greatly
gt; appreciated!