You can use vlookup which will update the sheet in real time rather than
running a macro to update it

This is what I would do:

Go to sheet B, lets say that column A is your ID numbers and column B is the
value that you want put into sheet A

i.e.

A B
id 71454 1000

Highlight column A and B together

Just above column A is a white box that should say A1 when you have
highlighted the columns

Click this box and type:

idvalue

now go to sheet A and click on a cell that you want o update the value then

enter

=vlookup(A1,idvalue,2,false)

You may need to change this to suit your form

What it does is lookup whats in A1 on your sheet

Then it looks for the range we have called "idvalue" and searches for the
same value in their

Then it moves to the cell to the right of it (thats what the 2 is for, it
might be the cell after that you want if it is then change this number to 3
etc)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1