Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TK TK is offline
external usenet poster
 
Posts: 177
Default 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