D
Dominique Feteau
I have 2 workbooks. One has a summary page with the names of clients and
the amount of their invoice for each month.(Columns are like: Client name,
Jan, Feb, etc.) The other workbook has some of that same information but is
separated by months on a different sheet. What I want to do is match the
amount of the invoice for each month that is on the second workbook with
that of the corresponding amount for that month in the first. right now i'm
using this formula: =IF(I6=SUM('[ActiveBillings2003.xls]2003
Summary'!$U$7:$U$8),"Same","Not Same").
Is there an easier way of doing this using an index statement?
Dominique
the amount of their invoice for each month.(Columns are like: Client name,
Jan, Feb, etc.) The other workbook has some of that same information but is
separated by months on a different sheet. What I want to do is match the
amount of the invoice for each month that is on the second workbook with
that of the corresponding amount for that month in the first. right now i'm
using this formula: =IF(I6=SUM('[ActiveBillings2003.xls]2003
Summary'!$U$7:$U$8),"Same","Not Same").
Is there an easier way of doing this using an index statement?
Dominique