Macro & Command Key to change data from Colums to rows

[Danno]

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 bil
of material. However this format does not work well with the way I a
developing a new work book for quoting.

I would like to develop a macro with a command key that changes the mf
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 t
this work book.

Thank you again for your help.

Da

 

[keepITcool]

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]

Does anyone have any ideas. This is the last piece I need to finish m
project.

Dan :

 

[Frank Kabel]

Hi Dan
have you tried 'keepitcool's' suggestions?