Thread: How do I create formula that allows the worksheet ref. to be chang
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I create formula that allows the worksheet ref. to be chang
You have a list of worksheets in E1:E10.

You have a DV dropdown list in A1 referencing that list.

In B1 you have this formula

=INDIRECT(A1 & "!D5")


Gord Dibben MS Excel MVP

On Tue, 6 Mar 2007 17:05:02 -0800, DMD1236
wrote:

Would like to allow user to be able pick amongst Multiple worksheets via
in-cell dropdown and formulas to change.

IE - what do I have to do to make

=SHEET1!D5

point to a cell and allow user tyo make it Sheet2! or Sheet 3! etc?

Reply With QuoteReply With Quote