Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Linking to a cell from within a header

Posted by Bill Fitzwater on September 27, 2001 6:22 AM

I want to link to a specific cell from a header, so that I can have several sheets headers linked to the same cell. That way I only have to update one place instead of remembering to update the header of each sheet.

Re: Linking to a cell from within a header

Posted by Angel on September 27, 2001 6:37 AM

I would suggest that the first sheet be the changing sheet and the rest of the sheets will flow with that one. On the other sheets simply go to the cell that needs tha same data and "= cell on first sheet" Under tools... options.... calculations..... you can set the sheet to calculate automatically or manually (F9). The size of the data or spreadsheet will help you determine which one you want to do.

Re: Linking to a cell from within a header

Posted by Bill Fitzwater on September 27, 2001 10:46 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.