Custom Fill/Enter?

T

Trevor J. Wilson

Is it possible to create a custom fill series that is activated when hitting
the enter button (as opposed to dragging with the Fill Handle)? What I
really want to do is to type a product number in column A, hit enter, and
have column B fill with a product name, and column C fill with the price. I
would like to do this with about 100 products. If there's a better way than
a custom fill series I'm open to suggestions.

Trevor
 
Top