excel front sheet

M

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.??
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 does not bring work sheet to the front. 3
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Imbedded Data Input sheet 3
Macro to add Multiple rows in same sheet 1
Excel 2007 1
is this possible in excel 2007 3
Auto Sheet Names and Date cells 3
Excel 2003 - Sheet Protection Causes Enter Key to Stop Working 2

Top