Help! Need formula to group similar text & numeric values onto seperate graph

Hi Everyone,

I am having trouble finding a Excel formula or VBA function that will group rows with common text values in excel to a condensed order synapsis similar to the shopping cart function you see on eBay amazon etc. I work for a door company and I have created an excel order form that generates the code needed to run our CADD software. However, I want to be able to receive the order and on a separate tab I would like the customer's order to be organized by the door profile name (stanwick riverton etc) as well as the shape(round square and size). All the other info from the form isn't necessary. This way I can put this info into my other charts and graphs so shop guys will know what the customer will be picking up as well as the ability for me to see sales trends. I am efficient in excel but do not remember much VBA codes from college. The form generates the information needed for the CADD software in columns N53:BD53 to N:154:BD154, I take this information and send it to another form which I then convert it to CSV to send to the software. Any idea on how I could do this would be great fully appreciated.

Maybe I should use the consolidate function however I'm not sure

Thank You

Also I am using excel 13

You could use code like this - it will remove any line where the grain direction has not been set

Please Login or Register  to view this content.

It's good to hear that you're feeling better....

You would insert a standard codemodule into your project, and place the code into that module. Then save the file as a macro-enabled .xlsm and run the macro either through the dialog or by assigning it to a commandbutton on your worksheet, run when the "Thermofoil" sheet is the activesheet, or change the line

Set SpecSheet = ActiveSheet ' Worksheets("Thermofoil")

to

Set SpecSheet = Worksheets("Thermofoil")

and then it won't matter which sheet is active.

And it does not create the CSV file - it creates a worksheet than can be exported to a CSV file - but one step at a time: that part can be added to the macro later.

Try to find any of John Walkenbach's Power Programming for Excel VBA series