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
(E-Mail Removed)
"Shane" <(E-Mail Removed)> wrote in message
news:1E7C40B7-F20E-48D9-9115-(E-Mail Removed)...
>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.