Can you auto fill down a column to repeat vendor names all at once.
G Gord Dibben Mar 24, 2005 #2 Perhaps. Are the vendor names in a Custom List in Tools>Options>Custom 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
Perhaps. Are the vendor names in a Custom List in Tools>Options>Custom 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