input field linked to button to create a table


first off guys id like to say hello! iv been stopping by the forums for
a few months now gathering my little nuggets of information! And it is
much appreciated!

basically my problem is i have created a large fully working rostering
form with counters, formatting and all sorts on the main form, this all
feeds back to a calculation sheet to calculate spare turns (turns that
are averaged from remaining hours ect.)
so my colleague loves the new form and has taken it to our boss who now
wants me to roll it out to other rostering clerks!!! EEEP! i think! as
he wants me to redesign it so that a user can input a number into the
starting form (refering to the number of lines/people he wants to be
generated, as all cleakrs have different and fluctuating members of
staff and therefor lines on the roster)

now i know my way around excel but have never touched apon macros and
buttons, i need it so that a user can pop a number in a cell then click
a button. then the button either pulls a default line and replicates for
the number in the box or just generates it into a new sheet.

1. is this possible
2.could you point me in the right direction for info relating to this or
maybe a demo form with a button similar to this that i can break down
and work with.

once again guys thanks for all the help you guys give and if you could
help me id be very appreciative!

sorry if its a bit confusing. if ya need any more info let me know.

regards
chris




--
omen666blue
.