Dynamic Named Range

I have a dynamic named range as follows:-

OFFSET([Employees.xls]Production!$A$1:$A$1,0,0,COUNTA([Employees.xls]Production!$A:$A)-1,12).

In MyBook.xls I have the formula INDEX(A1:B1,2), which I want to insert into the OFFSET function in place of the sheet name Production.

I say I want to because I can't get the syntax right! Can anybody help?

T.I.A.

Hi,

what exactly does the INDEX formula in MyBook.xls return? A file name? A text string?

Could you post example work books that illustrate what you have in place and what you want to achieve?

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!