ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with Custom View (https://www.excelbanter.com/excel-worksheet-functions/117455-help-custom-view.html)

vitorjose

Help with Custom View
 
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

Thanks for your help
Vitorjose


Debra Dalgleish

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


vitorjose

Help with Custom View
 
Thanks for the info

Debra Dalgleish wrote:
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




All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com