Hi,

I have a spreadsheet which allows a user to calculate their net pay (Irish tax rules) on a calendar year basis.
The workbook consists of a sheet named 'Simplifed method' (in which the user enters their gross pay) and a series of 'Reference data' sheets in which I store the various tax rules/ rates per year (so there's a Reference data 2009' sheet, 'Reference data 2010' sheet etc, one per calendar year)

My query:
On the 'Simplified method' sheet, I have a checkbox which the user can tick to signal that the value entered is a monthly salary amount rather than an annual amount. At present, this checkbox is (statically) linked to cell B82 in the 'Reference data 2009' sheet. While it is not absolutely essential (the link would not have to be dynamic to work), I'm curious to find out if it is possible to automatically update the check box's linked cell reference to the reference sheet based on the year the user selects-so the linked cell would be, say, cell B83 of the 'Reference data 2009' sheet if the 2009 year is chosen and cell B83 of the 'Reference data 2010' sheet if the 2010 year is chosen etc.

I suspect that this must be done using VBA if it is possible at all. I've had a look at macros (I'm not remotely approaching the level of a macro expert) but can't seem to generate the code to change the relevant checkbox property. I'm wondering if someone in the forum can confirm whether this dynamic linking of a cell is possible.

If necessary I can post a copy of the existing spreadsheet for review purposes.