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