View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mainsol mainsol is offline
external usenet poster
 
Posts: 3
Default formula drag down/copy changing integers of 6

Good Morning!

I am wondering how to copy a cell and paste it so that the cell reference
within the formula changes. For example:

=IF('EAST Region PSR Detail '!A9=""," ",'EAST Region PSR Detail '!A9)
when dragged down becomes
=IF('EAST Region PSR Detail '!A10=""," ",'EAST Region PSR Detail '!A10)

What I need to accomplish is to have the cell reference within the formula
to change by 6 integers vs 1, so the correct formula would be
=IF('EAST Region PSR Detail '!A15=""," ",'EAST Region PSR Detail '!A15)