sequence indirect formula

  1. M

    Sequence and indirect formula

    Hello, I have a problem creating a sequence of an =INDIRECT formula. Sheet2: Formula in C2: =INDIRECT("'"&$C$1&"'!A1") in "Sheet 2" C1: name of sheet1 Sheet1: Data in A1, A2 etc. Problem: I want to create a sequence of the formula in C2, A1 must change to A2, A3 etc Like this...

Some videos you may like

This Week's Hot Topics