For example, if your workbook has 5 reports, each of which shows the 'as at' date, just enter the date in the first report (i.e. cell B4) and for every other cell where you want that date displayed, type an equals sign followed by the cell address of the first date (i.e. =B4)

Make the formula an 'absolute reference' (i.e. =$B$4) so you can easily copy and paste the formula to all the other cells where you want to display that date.

Now each time you need to change the 'as at' date, you just change the date in the first cell and all the other dates automatically update.

Another option is to assign a name (i.e. AsAtDate) to the cell containing the first date and then for every other cell where you want that date, type an equals sign followed by that name (i.e. =AsAtDate).

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool prize. You'll be amazed how much time you'll save just by learning a few of these tips. Copyright © All Rights Reserved by