Macro Required to added week numbers to columns

Hi,

Every week I get sent a spreadsheet with the hours booked against specific codes, however, each weeks data is in a separate column (from weeks 1-52).

What I require is a macro that will check the heading title of each weeks data e.g. WK01, WK02 etc, work out what week it is and input the week number in a new column (Week No) corresponding to that weeks data.

Please see attached a sample spreadsheet for clarity.

I would be most grateful for any assistance in this matter

Many thanks in advance


Regards


Rob

N.B. Excel version 2003