I am wondering how to link a spreadsheet to a table that will allow
information from a a table to be autofilled into specific cells on another
sheet as I type similar information that matches certain cells. example
below.

Table
part number qty
xxx-01 10

Spreadsheet
when I type xxx-01 / 10 will be auto filled in.

Thank you for any help.

My understanding of what you want is:
In column A or sheet1, I type xxx-01. In column B, I want to have a
formula that returns 10. The table is in sheet2.

Let's assume that
- the table data is in the range Sheet2!A2:B10 (two columns, 1 header
row, 9 data rows)
- the table is sorted in ascending order of column A

The formula in cell B1 of sheet1 is
=VLOOKUP(A1,Sheet2!$A$2:$B$10,2)


cmaki1975 wrote:
I am wondering how to link a spreadsheet to a table that will allow
information from a a table to be autofilled into specific cells on another
sheet as I type similar information that matches certain cells. example
below.

Table
part number qty
xxx-01 10

Spreadsheet
when I type xxx-01 / 10 will be auto filled in.

Thank you for any help.