Can I generate several different reports from the same worksheet without overwriting the previous print specifications?
I have a worksheet that contains related information of different types. I need to print regular reports showing different aspects of the worksheet with different headings and in different formats. I believe I can get near to my requirements by using "Custom Views" but am not sure whether all the print options are preserved.
This is the sort of thing I know I could do with a RDB and SQL, but for historical reasons I am stuck with Excel.
I have a worksheet that contains related information of different types. I need to print regular reports showing different aspects of the worksheet with different headings and in different formats. I believe I can get near to my requirements by using "Custom Views" but am not sure whether all the print options are preserved.
This is the sort of thing I know I could do with a RDB and SQL, but for historical reasons I am stuck with Excel.
