Data consolidation & grouping

I am a real novice when it comes to Excel. Attached is a raw data file with multiple glass types and sizes. What I would like to be able to do is combine and total duplicate entries. I can sort easily enough but can't find a way to take say eight entries of the same "Tag, Glass Type and Size" and summarize the entire spreadsheet.

Attached is a revised copy of your workbook with three new sheets.
Each additional sheet (in order) shows the result of each step taken.

I am not sure it is what you want as the following is not clear to me...
"...take say eight entries...and summarize the entire spreadsheet."
'--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/XLCompanion

I have an old Lotus 123 Version 1.1 spreadsheet template that does what I'm looking for but can't get it to function in any newer version of 123 or Excel. I've attached a copy of the result I'm looking for in Excel using the same data file that I posted previously. I have to manipulate it in 123 V1.1 then open it in a newer version of 123 that doesn't recognize the macros and the save it as an Excel file in order to convert the decimals to fractions because our supplier won't accept orders unless they are in fractions.

The first attachment is just a screen capture of the macro menu you get when you hit "control Z", the other is the kind of sort I am looking to accomplish. I can send original the spreadsheet template if you think you can translate from early 123 to Excel.

We would be willing to pay to get the job done if you can guarantee the result.

Re:  "The first attachment is just a screen capture of the macro menu you get when you hit "control Z", the other is the kind of sort I am looking to accomplish."

There is only one attachment - a workbook with six sheets.  I see no screen capture.
It appears that the Lotus code (or something) is on hidden sheet "E".

Are you trying to convert decimals to fractions, do some sorting or ?

Jim Cone

The website would only let me attach one file so here is the screen capture. I can easily change the decimals to fractions in Excel once the data is sorted in 123 V1.1. What I am trying to do is get an Excel template that will accomplish the sorting of the data on sheet A (which is extracted as a .txt file from Autocad and then cut and pasted into the 123 spreadsheet template) into the format which is shown on sheet B "Sorted by wall type" and sheet C "Sorted by glass type".

I'm trying to eliminate having to use 123 for anything and do the entire process in Excel.

Here is the 123 template file saved as an Excel file with the "E" sheet unhidden if it helps.

I would have to have the Lotus application and have an understanding of the Lotus programming language to do the job you want.  I have neither.
I could start from scratch with Excel VBA, but you don't want to know what that would cost.

Maybe Bob Phillips, who posts here frequently would be interested.

If he doesn't speak up, you might try...
Debra Dalgleish... http://blog.contextures.com/about/
'--
Jim Cone