SOLVED

Very complicated formula sorting

New Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
Have you tried Indirect() function?
Are you referencing worksheets? or workbooks?
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