Copy and move info between files
I need to gather information from users and have the
information stored in a excel file on a sheet with 3
columns. That information is structured like this
PERSONID - VALUE1 - VALUE2
What I would like to do with this information is have a
button on another sheet which would look into the file and
look for the corresponding ID take values 1 and 2 then
paste them into the corresponding columns for the Person.
Instead of the row been deleted this would need to be then
moved into another sheet in case this needs to be checked
afterwards.
Any Ideas?
|