Copying A Link Formula

  • Thread starter Thread starter Learning VBA
  • Start date Start date
L

Learning VBA

I am trying to copy a link formula and having some problems.

This is the formula:
='01'!U141

The next few lines I want to look like these:
='02'!U141
='03'!U141
='04'!U141

I can not figure this out. Hope someone has the answer to this

I have about 31 rows and 40 columns that I need to do this with so doing
each one separately would take hours

Thanks in advance
 
=INDIRECT("0" & (ROW()) & "!U141")

Assumes entry in A1 of Master sheet and copied down.

Will pick up U141 from each of sheets 01, 02, 03 and 04


Gord Dibben MS Excel MVP
 
Back
Top