S
Steve
I have two nearly identical workbooks...one is a revision of the other.
They're names, for the sake of discussion, are Book1 and Book1_rev. They
have the same number of sheets and the same sheet names. If I have a formula
in Book1: +Sheet!A1 and copy it to Book2 I get the name of the workbook
(Book1). I know I can edit the formula but is there a setting I can change
that will not do it that way?
They're names, for the sake of discussion, are Book1 and Book1_rev. They
have the same number of sheets and the same sheet names. If I have a formula
in Book1: +Sheet!A1 and copy it to Book2 I get the name of the workbook
(Book1). I know I can edit the formula but is there a setting I can change
that will not do it that way?