Create a button that automatically fills out data

[Shane]

I have a stock transaction spread sheet that records movement of all stock in
and out, When ever i produce an item that has loads of items in its bill of
material, i have to manually add each record.
What i would like to acheive if possible, is to add a button (either macro
or Lookup)that when clicked automatically fills out the required info

Is this something that could easily be introduced, and if so can any one
please help in how i would set up something like this.

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.