I think the best advice I can give at this point is for you to look at the
Excel Help topic "Fill data in worksheet cells". There are several ways to
fill large groups of cells and that topic shows several.

"jdw" wrote:

Is there a function key that will repeat the value entered in the previous
column similar to access with out having to copy down?