first off guys id like to say hello! iv been stopping by the forums fo
a few months now gathering my little nuggets of information! And it i
basically my problem is i have created a large fully working rosterin
form with counters, formatting and all sorts on the main form, this al
feeds back to a calculation sheet to calculate spare turns (turns tha
are averaged from remaining hours ect.)
so my colleague loves the new form and has taken it to our boss who no
wants me to roll it out to other rostering clerks!!! EEEP! i think! a
he wants me to redesign it so that a user can input a number into th
starting form (refering to the number of lines/people he wants to b
generated, as all cleakrs have different and fluctuating members o
staff and therefor lines on the roster)
now i know my way around excel but have never touched apon macros an
buttons, i need it so that a user can pop a number in a cell then clic
a button. then the button either pulls a default line and replicates fo
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 o
maybe a demo form with a button similar to this that i can break dow
and work with.
once again guys thanks for all the help you guys give and if you coul
help me id be very appreciative!
sorry if its a bit confusing. if ya need any more info let me know.