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. 

AttachmentSize
7777.xls23 KB
LogIssues.xls37.5 KB

NICK the file is attached let

NICK the file is attached let me know what I can do

Nick's picture

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?

 

Nick's picture

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

 

 

Nick's picture

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

 

Nick's picture

file attach

hi.. you can attach the file to your post..