MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

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.

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