How create a formula to copy but have the row change by fixed number? - TechRepublic
Question
August 16, 2011 at 11:11 AM
kicove

How create a formula to copy but have the row change by fixed number?

by kicove . Updated 14 years, 10 months ago

I need to extract data from worksheet called “KI” to another worksheet called “Summary”. So for the first reference I used this formula =’KI 2011′!L16 The next cell I need to reference =’KI 2011′!L23 I need to repeat this many times but the only change is the row number which ALWAYS increases by 7, so next reference would be =’KI 2011′!L30 and so on. Is there anyway to do this automatically with a formula so I don’t have to keep selecting the cells hit = then go to the KI worksheet select the cell and hit enter? It would save alot of time from having to do that over 100 times. Thank you.
Using Excel 2007

This discussion is locked

All Comments