Yes, there is a way to get a cell value in a page header without using VBA. Here are the steps:
- Click on the "Insert" tab in the ribbon.
- Click on "Header & Footer" in the "Text" group.
- Choose the header or footer section where you want to insert the cell value.
- Click on "Insert Sheet Name" or "Insert Workbook Name" in the "Header & Footer Elements" group. This will insert the name of the sheet or workbook into the header or footer.
- Click on the location where you want to insert the cell value.
- Type an ampersand (&) followed by the cell reference of the cell you want to reference. For example, if you want to reference cell A1, type "&A1" (without the quotes).
- Press Enter to finish.
The cell value will now appear in the header or footer. If the cell value changes, the header or footer will update automatically.