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:





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)
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