excel front sheet

[manmah]

Don't know if this is possible?? I have a excel doc which basically
calculates lots of different costs. I want to use a front sheet which
has fields of input a "GO" button to export the data to the relevant
sheet and then clears ready for the next entry. Is it possible within
Excel or will my front sheet need to be done in access. If so how do I
do that.??

 

[Ron@Buy]

In 2007:
Click the office button > Excel Options > customize, then select commands
not in the ribbon from the choose commands from toolbar, scroll until you see
form and add it - you will then see an icon of a form in the 'Quick access'
toolbar (probably situated along the top of your screen.