Macro & Command Key to change data from Colums to rows
 

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

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

Macro & Command Key to change data from Colums to rows
 

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/

Macro & Command Key to change data from Colums to rows
 

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

Dan :

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

Macro & Command Key to change data from Colums to rows
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

Dan :(


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