As engineers go... there format is well structured,and pretty good for
analysis. (though for clarity I'd put the uniqueID (wid123,wdg345..) in
the first column)

Your layout appears to group their stuff by artGroup.
the easiest way to convert their table to your layout would be to use a
Pivot table... which makes it flexible and you'd need no code.

learn to use Pivots, you just might impress your colleagues :)



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Danno wrote:

Hello again,

This forum helped me with my last problem and now I have a new one.

The enginneering department has a format they use when creating a bill
of material. However this format does not work well with the way I am
developing a new work book for quoting.

I would like to develop a macro with a command key that changes the
mfg and mfg part #s from colums to rows.

Their format is as follows

A widgit 1 ACME wid123
A widgit 1 ABC CO wdg345
B screw 3 Acme scw678
C ......

I hope you get the idea.

I would like to see it this way for the report

A widgit 1 Acme wid123 ABC Co wdg345
B screw 3 Acme scw678

I am not very familure with macros but feel it would be benifical to
this work book.

Thank you again for your help.

Dan


---
Message posted from http://www.ExcelForum.com/