I have a file having so many part code and supplier of each part code.



Now,I want that a part code should appear at once in a row and each supplier of that part code against that column.

Please refer attach file for more clarification.
In this file,column B and C consists of Part code and supplier.But the reqd.result is appearing from E to K column.

Is it possible from an excel formula?

Attached Files

Book1.xlsx (8.7 KB, 11 views)

A person has sent to me a file which is macro-enabled file.Can anybody help me to understand the file step-by-step that how has he worked out in this file?I am unable to self understand the working of that file.
For more clarification,please refer the attach file.

Attached Files

Pradeep.xlsm (18.8 KB, 9 views)

Yes, it's possible, but the formulae are complex. See:
http://windowssecrets.com/forums/sho...l=1#post734296
http://www.techsupportforum.com/foru...ml#post2567119

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

That suggests you have posted a question about the same issue in another forum. If so, please read: http://www.excelguru.ca/content.php?184 and post a link here to your thread in that forum. Do likewise for the other forum also.
Have you had a look at the macro code? Have you asked the person who provided it to explain it?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]