I'm looking to compare two different work books. I have nothing to go
off of to get what i'm looking for if some one could help that would be
great.

What i'm trying to compare is multiple bill of materials. I am going
to have a master for every class of boxes we build.

1 is there a way to take a bom from my email when it is emailed to me
from our engineer?

i have a file with all the emailed boms.

i want to compare so that it compares the two diffent workbooks and
highlights the differences. Here is the kicker when he does the bills
some have lines for the description and some of the parts aren't always
in the same order for example

1 it could be
1 ea 01140.9
2 ea ru6029

or

2 ea ru6029
1 ea 01140.9

example 2
4 ea sr3p
part of the description no part number in this line
1 ea 350
2 ea drtd2
3 ea sr2p

or
3 ea sr2p
4 ea sr3p
1 ea e350
2 ea drtd2

i hope you get the gist of it i want to include the quanity of each
the spaces = the seperation of the colums
so 1 in colum e, ea if colum f, part number(01140.9) in colum g

can this be done please help

i will attach a couple


+-------------------------------------------------------------------+
|Filename: L9252.xlsx |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=160|
+-------------------------------------------------------------------+

--
nathanv3223
------------------------------------------------------------------------
nathanv3223's Profile: http://www.thecodecage.com/forumz/member.php?userid=159
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105303