View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pat Fern Pat Fern is offline
external usenet poster
 
Posts: 1
Default 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?