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
|