Autofill from list for vlookup

[laxmaster3000]

I have created a workbook to keep track of orders from suppliers, I'm currently trying to build on it. I have a list of suppliers on one sheet, I have other sheets representing the a certain week of the month (1,2,3,4).

On another sheet, I'm using vlookup to calculate a summary of the bill totals for each supplier at the end of the month.

The problem is I'm worried if I have a typo on the name of the supplier it won't appear on the calculation, I created a dropdown list but its quite tedious..

Does anyone know a way to autofill (if that's the correct term) the name of the supplier as I type it in the cell?

Previously I had all the suppliers on every worksheet but it creates problems when we switch/add/drop companies

 

[JoeMo]

anyone know a way to autofill (if that's the correct term) the name of the supplier as I type it in the cell?

Don't think that can be done, but you could use a change_event macro to check the typed entry against a spell-checked list of suppliers to see if its on that list. If not, the entry could be undone and the user asked to re-type a valid supplier name.

If that's of interest, tell us the name of the worksheet and range on that worksheet that holds the "spelling-approved" list of suppliers.