Forum Discussion
Solved
Very complicated formula sorting
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.
- Have you tried Indirect() function?
Are you referencing worksheets? or workbooks?
- 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
