automatic increment function by row

**geostationary** · 07-10-2013, 11:54 PM

Just learning Excel, probably a basic question.

Here's what I have:

Cell C12 =Classroom!E3
Cell C13 =Classroom!F3
Cell C14 =Classroom!G3

I just want to automatically continue the pattern down through the remaining 500 rows without having to update each of them manually.

Thanks for any guidance.

**FDibbins** · 07-10-2013, 11:58 PM

Hi and welcome to the forum

JUst so that I understand...you want to reference consecutive COLUMNS as you copy the formula down ROWS?

**humdingaling** · 07-11-2013, 12:02 AM

try
=INDIRECT("Classroom!"&CHAR(68+ROW(A1))&"3")

Char 68 = D
row a1 = 1
so char 69 = E
as row increases so does the letter

**FDibbins** · 07-11-2013, 12:15 AM

Hum, that will work up to Z, but the OP said they have 500 rows? That takes them to SJ

**humdingaling** · 07-11-2013, 12:18 AM

yes you are correct
sorry
use this instead

=INDIRECT("classroom!"&ADDRESS(3,ROW(A5)))

address (row,column)
address ( 3 , row(a5) =5)
address (3,5) = e3
as row increases so does the column reference

**geostationary** · 07-11-2013, 02:21 AM

Thank you for the incredibly fast and accurate response. The "index" function is exactly what I needed, and when I plugged it into the cells and dragged the little + sign down, all was right with the world. WAY easier to update the worksheets now. Many, many thanks.

**FDibbins** · 07-11-2013, 01:17 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.