R
R Green
hi
i was assigned to do this for a senior manager and i have limited knowledge
of excel (i am the most knowledgeable in our company!)...
In any case, I have the following problem:
Two worksheets with inventory parts number. One worksheet was obtained from
an actual physical count, while the other was from a parts software
database. In another words, we're trying to compare both worksheets info to
each other.
Instead of doing this manually, is there a way to enter a formula or two or
three to compare say, parts number on each worksheet and then extract the
same matching numbers into a third worksheet, along with the prices that
comes along with each worksheet and then spits out what parts did not match
between the two worksheets??
Any help would be appreciated!
Thanks!
i was assigned to do this for a senior manager and i have limited knowledge
of excel (i am the most knowledgeable in our company!)...
In any case, I have the following problem:
Two worksheets with inventory parts number. One worksheet was obtained from
an actual physical count, while the other was from a parts software
database. In another words, we're trying to compare both worksheets info to
each other.
Instead of doing this manually, is there a way to enter a formula or two or
three to compare say, parts number on each worksheet and then extract the
same matching numbers into a third worksheet, along with the prices that
comes along with each worksheet and then spits out what parts did not match
between the two worksheets??
Any help would be appreciated!
Thanks!