Macro to update the date column for certain rows in a table depending on a column value

Hi, I have an existing excel table that requires the following added functionality.

If the value in column called movement is equal to SCHOOL AM or SCHOOL PM then update the Date column for that row by 1 day. I'm just unsure how to handle if it is Friday to add 3 to the current date instead of just 1 to the current date. Also, would the function be able to handle the end of the month and roll the date over appropriately. I figure I would run the macro at a certain time during the current day to roll over the date for the found rows (which would run around 80 - 120 rows daily). If someone could provide me the formula or function to use to roll the date over properly that would be great. I have some coding that uses IF statements to find the correct row in the table but I wonder if CASE statements may work better in this situtation. I also jsut thought about the issue of the Macro set to run every day that may screw up the rolling of the dates during the weekend. Is their a time function that I can use to ensure that the marco only runs from Monday to Friday?

Thanks,

A

Hi Holger the information in confidential but I can provide a quick layout for explaination

Worksheet name dailymovement
excel table name is movement

Columns A b c d
Person movement type time and location date of movement

rows Smith Doctor am

Hi, this looks very close to what I'm looking for. I will test it out in a test copy of the excel file. Would the coding be any different if I refer to the excel table name instead of the worksheet name?

I will update this thread, once I test tomorrow.

Thanks,

Anne

Hi Hoilger, it works exactly the way I needed it to work. Thank you so much.

Cheers,

Anne