Update a data entry for one month (and the rest of the year)

[Ewa]

See a data entry form attached which is to be used to track staff movements, changes promotions over time.

The data (AssociateData) lists all workers in the team and each worker has a row per month. The manager of these employees will use the Input sheet to update employees data (e.g. changes of site, change to the role name, job level etc.).
They will firstly select at the top (J1): Period of when the change commenced (let's say March, 2017), line manager and employee name and the form will appropriately change in the range D5:D19.

When you change e.g. job level (D10) for one person this change currently only change for this person for March 2017, but not for future months i.e. April 2017, May 2017.

Any idea what to do to the existing macro code in the file for it to work?


Thanks

Ewa

 

[vletm]

few ideas:
1) [Period] have to have Dates = day/month/year (not just month, year)
=> possible to know next month
2) [NameAssociateNumberNo]'s period part have to modify
=> Looks same as before
3) Sub UpdateLogRecord() ... [Update]
=> that 'Update's only current row
=> gotta make some kind of loop which checks future months too
OR
make a new Macro which makes that loop [Update All],