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
Copy the content of a cell with Formula 1
How to use cell reference? 9
Use a variable in a ShapeRange.Increment 0
Filtering without filtering 3
Countdown macro - display settings 2

Top