Prev: create a rack diagram in Excel
Next: How do I delete rows based on a category?
From: rudyeb on 19 Jan 2010 09:44
I get updates weekly from one of my customers that list all the parts
we make and when they are due for delivery. I would like to be able
to
download the file and compare it to the previous week to see if there
are any changes in quantity ordered or date due. Is there a way I can
do so and have the changes highlighted in a different text color or
some other means of letting me know what has been changed?

Thank you,


From: Luke M on 19 Jan 2010 11:51
With a helper worksheet/workbook, use a formula like this in cell A1:
='Book1'!A1='Book2'!A1

Copy across/down as needed. Anywhere "FALSE" is displayed, there is a
difference. You could even apply a conditional format so that all the FALSE's
are highlighted and stand out.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rudyeb" wrote:

> I get updates weekly from one of my customers that list all the parts
> we make and when they are due for delivery. I would like to be able
> to
> download the file and compare it to the previous week to see if there
> are any changes in quantity ordered or date due. Is there a way I can
> do so and have the changes highlighted in a different text color or
> some other means of letting me know what has been changed?
>
> Thank you,
>
>
> .
>
 | 
Pages: 1
Prev: create a rack diagram in Excel
Next: How do I delete rows based on a category?