View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Help with Custom View

You could have each view's heading in a different row. Then, hide all
the other heading rows when you create each view.

vitorjose wrote:
I have created a series of reports from a common table using custom
views. I want the title of the report to change based upon the view
selected. Is there any way to have a cell display the view that is
currently being applied. I know that i can change the header / footer,
however i would prefer to place the title in a cell within the
spreadsheet


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html