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.