Thread: Copy Down
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yrrep Yrrep is offline
external usenet poster
 
Posts: 11
Default Copy Down

I want to copy the formula below down the sheet so that the week
increases. i.e. week 12 week 13 etc. (The week represents a different named
sheet)

=IF(Week12!L$3=0,"",Week12!L$3)