dynamic linking worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I know how to pull data from one worksheet to another i.e. ='2660'!$H$2.

But I want to replace the 2660 with a cell ref on the destination worksheet
i.e. ='A2'!$H$2 as this contains the source worksheet's name.

But this does not work.
An ideas how I can do this?
 
Back
Top