Hi, what I would like to do is copy and paste from a workbook onto the first
sheet of another work book; the first column (A) has a persons name and the
next seven columns have data in them, my problem is that the names change
order each week so what I would like to do is transfer some of the data from
the first sheet to the next sheet by typing in the name in column A and the
data associated with that name goes into columns B/C/D, automatically. This
way the names will all ways be in the same order when I copy them some where
else.
Can any one help? Thank you in advance .Tommy