Forum Discussion

DamianHorbeek's avatar
DamianHorbeek
Copper Contributor
Feb 21, 2023
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 ='...
Formulas and Functions
  • FikturFox's avatar
    FikturFox
    Feb 21, 2023
    Have you tried Indirect() function?
    Are you referencing worksheets? or workbooks?
FikturFox's avatar
FikturFox
Brass Contributor
Feb 21, 2023
Have you tried Indirect() function?
Are you referencing worksheets? or workbooks?
  • DamianHorbeek's avatar
    DamianHorbeek
    Copper Contributor
    Feb 21, 2023
    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

Resources