View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] nt8jbwu02@sneakemail.com is offline
external usenet poster
 
Posts: 7
Default evaluate cell value with sheet name

I have different sheet names in column A. I would like to use the
sheet value in A to show a value in a specific cell in that sheet.

For example:

A12 has 'Test 1 & 2' (no 's) and I would like cells b12 and c12 to be
'Test 1 & 2'!A50 and 'Test 1 & 2'!A60 respectively. However, I do not
want to hard code the 'Test 1 & 2' text but would rather use the fact
that this string is already available in cell A12.

How can I do this?

Thanks