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.

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shane" wrote in message
...
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.