sublime1184
11-02-2006, 4:01 PM
so on my master ref page my formula is this:
='X:\Receipts\Nov\[Receipts-week of 11-06-06.xls]Smith,J'!$H$3
and I want to replace it to say:
='X:\Receipts\Nov\[Receipts-week of 11-13-06.xls]Smith,J'!$H$3
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?
='X:\Receipts\Nov\[Receipts-week of 11-06-06.xls]Smith,J'!$H$3
and I want to replace it to say:
='X:\Receipts\Nov\[Receipts-week of 11-13-06.xls]Smith,J'!$H$3
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?