input field linked to button to create a table
- From: omen666blue <omen666blue.a23ea28@xxxxxxxxxxxxxxx>
- Date: Sun, 17 Jun 2012 16:37:41 +0000
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
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.
- Prev by Date: Re: Calculating Work Time
- Next by Date: Re: input field linked to button to create a table
- Previous by thread: Summarise data on multiple sheets
- Next by thread: Re: input field linked to button to create a table