Excel Issue for Engineers
Im trying to create a sheet that essentially saves entered data into a seperate sheet dependent upon which type of data is entered.
Ex. Customer Service problem
The user enters what type of problem from a list in an existing sheet:
1. manufacturing defect
2. Vendor issue
3. Shipping
And if Shipping is selected then that entire row will be saved in a sheet labeled Shipping, and like wise for other options selected.
Attachment | Size |
---|---|
7777.xls | 23 KB |
LogIssues.xls | 37.5 KB |
NICK the file is attached let
NICK the file is attached let me know what I can do
Issue logging system
Hi Matt
I have created a simple issue logging system for you.
Check it out, and feel free to ask questions.
LogIssues.xls
Nick
Thanks
Works Like A Charm...Your the Man! how do i pay you?
Issue logging system
All quick help is free on this forum.... for anything that takes a while, we offer consultancy.
Here's the link to request a quote if you have a big project that needs work
If you'd like to say thanks, tell everyone about ExcelExperts.com !
Nick
Saving and loading example
Hi Matt
We have a good example of saving and loading from an input sheet to an excel-style database using VBA.
Have a play with this:
excelexperts.com/Share-Trading-System
To answer your specific question, Here's the VBA to select the sheet based on the value of a cell that you have called "Customer Service problem":
Sheets(Range("Customer Service problem").value).select
or if it's not a named range:
Sheets(Range("A1").value).select (if it's in A1)
Nick
Nick
Thank you for the quick rsponse. I'll give it a shot! Im sure I'll have more questions since it is for a TQM process.
Nick, I think I may need your
Nick,
I think I may need your assitance on this....Can I send you the file to look at? Im sure if you show me how to write the code for one example then I can go from there.
Also, I like the idea of using the buttons like a User interface.....maybe we could do that as well....all I need is a "Save Button"
Let me know if you can help me out on this one
file attach
hi.. you can attach the file to your post..