Very complicated formula sorting

[DamianHorbeek]

Hi all,

This is my first time on the forum with a complex problem.

I want to have the possibility to drag the following formula down with the right continuation:

='AA01'!B20

='AA02'!B20

='AA03'!B20

How can I do this? When I try to automate it the cells keep moving to B21, 22 ,23 and the AA01 keeps repeating. It doesnt understand that i want the have the AA till 88 or something.

[#2 · Accepted solution]

Have you tried Indirect() function?
Are you referencing worksheets? or workbooks?

[#3]

I guess I somehow solved it with indirect function now yes. Thanks.

Still a lot of work to be done with over 200 rows and 15 columns but it's fixed now