copying formulas

M

mainsol

Hi!

I am looking for a way to work smarter..! I am wondering how to copy a
formula to the cell below but change the reference in the formula at the same
time.

For example; =IF('EAST Region PSR Detail '!A9=""," ",'EAST Region PSR
Detail '!A9)
if you drag this down to the cell below, the cell reference will change from
A9 to A10. I am looking to get it to change in intervals of 6 instead of 1.
So the cell below would be A15 instead of A10.

Thank you!
 
M

muddan madhu

two ways
1. select the cell, press F2 , copy the formula from formula bar and
paste it.

2.change the reference style =IF('EAST Region PSR Detail '!A$9="","
",'EAST Region PSR
Detail '!A$9)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying formulas and changing cell references 3
formula drag down/copy changing integers of 6 2
mutliple matches for v lookup 2
How to use cell reference? 9
Calculating sum product between columns. 3
Filtering without filtering 4
Formula Problem 3
Excel 2007 Conditional Format with Formula 5

Top