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