Turning a Formula to VBA code

[damaple]

Hi,

i have a formula that's located in sheet named "test":

Please Login or Register  to view this content.

it takes the date of the day (the bold cell) if in that day the word test is found.

in the current situation i need to copy and change this formula to the current week, because everyweek have its own sheet.
how do i make it work for all the weeks?
i mean that the code is checking for the sheets starting with the word week, then searching in the column for the word "test" then if its true it will paste the date in the cell at the test sheet.

Thanks for your help!

[LJMetzger]

Try the following Macro (written and tested using Excel 2003):

Please note that there are several methods of defining 'Week' of the year.

Lewis

Please Login or Register  to view this content.