How do I attach data to auto complete
 

Is it possible to attach date to auto comlete so that when I use auto
complete it not only completes the name but fills in cells in the new row
with the same cell data that was used in the above row that contained the
same name? If this is possible, it would be easier than having to use cut and
paste. Regards