Formula

[YOUNAN]

Hi,

I need a formula to
cell K3 to equal n3 from sheet with name 60001
cell k4 to equal n3 from sheet with name 60002
cell K5 to equal n3 from sheet with name 60003
and so on.

or in another words if i drag down the formula it will change the sheet number and increase it by 1, without changing the equal cell which is N3

Thanks in advance

best regards

 

[Special-K99]

in K3
=INDIRECT(60000+ROWS($1:1)&"!N3")
and copy down the column

 

[tyija1995]

Hello,

Try this code:

Sub FormulaK3UsingN()
    Dim i As Long
    
    For i = 3 To ActiveWorkbook.Sheets.Count
        Cells(i, 11).Formula = "=" & Sheets(i).Name & "!N3"
    Next i
End Sub

Make sure you run this in the sheet that you want the formulas in!

 

[YOUNAN]

Hi,

Thanks a lot, it worked as charm.

Best Regards