Adding a date value to the header of EXCEL worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1174264%22%20slang%3D%22en-US%22%3EAdding%20a%20date%20value%20to%20the%20header%20of%20EXCEL%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1174264%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20about%2010%20worksheets%20in%20it.%20I%20update%20two%20of%20the%20sheets%20and%20the%20rest%20are%20populated%20based%20on%20the%20information%20I%20add%20to%20the%20first%20two%20worksheet.%20However%2C%20I%20need%20to%20print%20each%20of%20the%20worksheets%20as%20a%20report.%20In%20doing%20so%2C%20I%20have%20the%20%22week%20ending%22%20date%20(e.g.%26nbsp%3B%20%22for%20the%20week%20ending%2009%20Feb%202020%22)%20in%20the%20header%20of%20each%20worksheet.%20Is%20there%20any%20way%20to%20enter%20that%20date%20once%20and%20have%20it%20replicated%20to%20all%20of%20the%20other%20worksheets%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EElder%20Bob%20Bell%3C%2FP%3E%3CP%3EFinancial%20Secretary%3C%2FP%3E%3CP%3ENebraska%20Omaha%20Mission%3C%2FP%3E%3CP%3EThe%20Church%20of%20Jesus%20Christ%20of%20Latter-day%20Saints%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1174264%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177480%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20date%20value%20to%20the%20header%20of%20EXCEL%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177480%22%20slang%3D%22en-US%22%3EIf%20you%20enter%20it%20in%20Sheet1%2C%20cell%20A1%2C%20for%20example%20and%20you%20want%20it%20also%20to%20duplicate%20in%20cell%20A1%20of%20Sheet2%20the%20just%20type%20%3D%20into%20A1%20on%20Sh2%2C%20click%20on%20the%20Sheet1%20tab%20then%20click%20on%20Cell%20A1%20(where%20the%20data%20is%20entered)%20and%20then%20hit%20return%20-%20you%20should%20find%20that%20the%20entry%20is%20linked.%20As%20you%20update%20Sheet1%2C%20so%20to%20will%20links%20to%20it%20in%20other%20sheets.%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a workbook with about 10 worksheets in it. I update two of the sheets and the rest are populated based on the information I add to the first two worksheet. However, I need to print each of the worksheets as a report. In doing so, I have the "week ending" date (e.g.  "for the week ending 09 Feb 2020") in the header of each worksheet. Is there any way to enter that date once and have it replicated to all of the other worksheets?

 

Thanks,

Elder Bob Bell

Financial Secretary

Nebraska Omaha Mission

The Church of Jesus Christ of Latter-day Saints

1 Reply
If you enter it in Sheet1, cell A1, for example and you want it also to duplicate in cell A1 of Sheet2 the just type = into A1 on Sh2, click on the Sheet1 tab then click on Cell A1 (where the data is entered) and then hit return - you should find that the entry is linked. As you update Sheet1, so to will links to it in other sheets.