Thread: Copying problem
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
 
Posts: n/a
Default Copying problem
Hi Martin,

Or this:

=IF(INDIRECT("WORKSHEET!C" & (ROW()-18)*12 + 10)
=0,"",INDIRECT("WORKSHEET!C" & (ROW()-18)*12 +12))

Ken Johnson

Reply With QuoteReply With Quote