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