Home » Forums » Open Source Learning Center » Question and Answer

Excel Issue for Engineers

Submitted by Matt Holling on 20 January, 2010 - 13:18

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
‹ Hidden Filters in Excel Creating a specific EXCEL program. ›
»
Nick's picture

Saving and loading example

Submitted by Nick on 20 January, 2010 - 15:21.

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

Submitted by Matt Holling on 20 January, 2010 - 16:15.

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

Submitted by Matt Holling on 20 January, 2010 - 17:12.

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

Submitted by Nick on 21 January, 2010 - 08:09.

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

»

NICK the file is attached let

Submitted by Matt Holling on 22 January, 2010 - 15:00.

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

»
Nick's picture

Issue logging system

Submitted by Nick on 22 January, 2010 - 15:26.

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

Submitted by Matt Holling on 22 January, 2010 - 15:55.

Works Like A Charm...Your the Man! how do i pay you?

 

»
Nick's picture

Issue logging system

Submitted by Nick on 22 January, 2010 - 16:15.

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

 

 

»