Thread: How do I create formula that allows the worksheet ref. to be chang
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DMD1236 DMD1236 is offline
external usenet poster
  
Posts: 3
Default How do I create formula that allows the worksheet ref. to be chang
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