Hey guys,

I am sure many of you would have faced such questions as i have and this led me to think and think...so i started this thread.

I have seen several OPs asking for questions requiring simultaneous update between files .for e.g. I want this master file to be updated as soon as there is an entry n the team member's file, if i change the dept name in this row, the data should be removed from the old dept tab and copied to the new dept tab, etc. What do you think is the best way to do this?

I thought of the following options -

1. On a worksheet event, clear the destination sheet completely and reload with the required data.
2. On update, check if the row already exists. If not, copy it in the next available row. But how do i check? Keep running a "find" query? If not found, then update?

Please advise. I really want to learn something out of this.