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

If you will only have one value per row you can use a formula such as:

Please Login or Register  to view this content.

I used D:BC for 52 weeks.

If you want this in VBA you will need to elaborate in terms of how you receive the data... ie insert column etc... it's all a little too vague I'm afraid.

DonkeyOte

Many, many thanks for your prompt reply - the code works as required.

Best regards


Rob