Is there an easy way of incorporating the contents of a cell in the Custom Header (or footer) for that page in a workbook? I want to incorporate a % figure in the header so that it updates when I amend the percentage figure in cell A1. The figure must be formatted as e.g. 5% and not .05.
Can this be done?
Can this be done?