so on my master ref page my formula is this:
and I want to replace it to say:
The name of each sheet is different and I have about 45 sheets ("Smith,J" will keep changing). Do I have to do it manually or can I use a trick in Edit>Replace and replace only the first "06" in the code?
Code:
='X:\Receipts\Nov\[Receipts-week of 11-06-06.xls]Smith,J'!$H$3and I want to replace it to say:
Code:
='X:\Receipts\Nov\[Receipts-week of 11-13-06.xls]Smith,J'!$H$3The name of each sheet is different and I have about 45 sheets ("Smith,J" will keep changing). Do I have to do it manually or can I use a trick in Edit>Replace and replace only the first "06" in the code?
