Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

locate and update cell

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Locate and update cell from a different worksheet

Locate and update cell from a different worksheet

ResolvedVersion 2016

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.

RE: Locate and update cell from a different worksheet

Not to worry, I did it the other way.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.