Print title rreference another spreadsheet

Hi,

I have a spreadsheet with title as a separate sheet. Is there a way to make that become the title on another sheet?

The reason for having the title on another sheet is so I can have the next sheet hide columns that are not needed for that particular report. If it is on the same sheet then the hidden columns will affect the title that I do not want hidden.

Are there any suggestions on how I can accomplish this?


Thank you,

BI

Not certain what you are asking.

Please be more definitive and/or attach a sample file showing what you have and what you want it to become.

You can refer to the contents of cells in another workbook by creating an external reference. An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook. You can refer to the specific cell range.
Is that what you want?