dynamic linking worksheets
 

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?

dynamic linking worksheets
 

Try this with the sheet name in A1

=INDIRECT(A1&"!H2")

Mike

"Jake Sale" wrote:

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?

dynamic linking worksheets
 

=INDIRECT("'"&A2&"'!$H$2")
--
David Biddulph

"Jake Sale" <Jake Sale @discussions.microsoft.com wrote in message
...
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?