Diane has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course
Locate and update cell from a different worksheet
Is there a shorthand code I could write to do the following? I know the long way would be to activate the worksheet find my record in the current region and then offset to a column on the row. Could I do it instead without hopping from one worksheet to another and then hopping back to my original worksheet?
So to put some detail behind it
I am in a sheet called Absences where I have calculated accrued sickness for a given employee (from a table of absences for all employees). I want to use that value (itotsick) to update the employee Sickness Total (col T) on a worksheet (PR) that has one row per employee which is an employee record. As i mentioned ideally I would like to do that from my last position on the absence worksheet because the HR staff will be entering any number of absence records at one time. Many thanks.