formula
 

A workbook has two Sheets named
July-702 and July-703

A cell in July-703 has a formula =July-702!A1

Now you €œcopy€� the sheets and rename the copies
Aug-702 and Aug-703 €“ the originals remain and
you now have 4 sheets

Can you write the formula so the copy in this case
Aug-703 refer to Aug-702

Thanks TK

formula
 

Edit=Replace
What July
With Aug

uncheck complete words and have it look in formulas.

--
Regards,
Tom Ogilvy


"TK" wrote:

A workbook has two Sheets named
July-702 and July-703

A cell in July-703 has a formula =July-702!A1

Now you €œcopy€� the sheets and rename the copies
Aug-702 and Aug-703 €“ the originals remain and
you now have 4 sheets

Can you write the formula so the copy in this case
Aug-703 refer to Aug-702

Thanks TK

formula
 

Thanks Tom

That works


Regards TK

"Tom Ogilvy" wrote:

Edit=Replace
What July
With Aug

uncheck complete words and have it look in formulas.

--
Regards,
Tom Ogilvy


"TK" wrote:

A workbook has two Sheets named
July-702 and July-703

A cell in July-703 has a formula =July-702!A1

Now you €œcopy€� the sheets and rename the copies
Aug-702 and Aug-703 €“ the originals remain and
you now have 4 sheets

Can you write the formula so the copy in this case
Aug-703 refer to Aug-702

Thanks TK