FAO - Excel Gurus
Discussion
Right I don't normaly revert to asking for help but. I've about exhausted the Excel help and I consider myself pretty advanced. However I have no Forms experience.
I'm trying to create a customer aftersales database which will keep on one sheet customer details. I then want to use a form to enable the user to add incident details which will be stored on a hidden database sheet. This will then enable me to run report/graphs etc on the detail on this hidden sheet.
Esentialy I don't know how to create a form which I can raise via a button which will only show certain data from the database ie filtered based on their name etc.Ie so when you click on the button next to their details a form with the feild comes up but will only show their previous incidents.
Hope this makes sense, does anyone therefore have such a spreadsheet or can tell me how to create a (protected) filtered data entry form.
Many thanks in advance assuming I haven't stumped the global PH ability.
I'm trying to create a customer aftersales database which will keep on one sheet customer details. I then want to use a form to enable the user to add incident details which will be stored on a hidden database sheet. This will then enable me to run report/graphs etc on the detail on this hidden sheet.
Esentialy I don't know how to create a form which I can raise via a button which will only show certain data from the database ie filtered based on their name etc.Ie so when you click on the button next to their details a form with the feild comes up but will only show their previous incidents.
Hope this makes sense, does anyone therefore have such a spreadsheet or can tell me how to create a (protected) filtered data entry form.
Many thanks in advance assuming I haven't stumped the global PH ability.
How are you with VB?
You can add in a VB-esque form through the Visual Basic editor in Excel to which you can add buttons, drop downs etc, but you will need to write macros to send and retreive your code.
To add a form open the VB editor in excel, then add in a form through the insert menu.
If you have no experience with VB you will need to read up on it first.
Not much help, I know, but there is rather a lot to it I'm afraid
You can add in a VB-esque form through the Visual Basic editor in Excel to which you can add buttons, drop downs etc, but you will need to write macros to send and retreive your code.
To add a form open the VB editor in excel, then add in a form through the insert menu.
If you have no experience with VB you will need to read up on it first.
Not much help, I know, but there is rather a lot to it I'm afraid
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff