Perhaps.

Are the vendor names in a Custom List in ToolsOptionsCustom Lists?

If so, just type one of them then right-click and drag down.

Release the button and select "Fill Series".

Otherwise..........???


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 12:47:04 -0800, Confused?
wrote:

Can you auto fill down a column to repeat vendor names all at once.