I want to take data from one sheet and transfer it onto another sheet.
This does not involve a simple copy or cut and past.
Thus,
The data on one sheet will be in rows eg /Jeff/ 56 / 78 / 897 / 789 /
/Lisa/ 890 / 765 / 6789 / 2344/
/Jane/ 8 / 34 / 7832 / 7893 /
On the second sheet, i want to automatically obtain or retrieve the numeric data for Jane by typing in "JANE'' ,
Lisa by typing in "LISA
or
Jeff by Typing in "JEFF''
Thus regardless of the order in which i enter a name in a given column in the second sheet, i want the numeric data for that individual to load up along that row.
Is this possible?
What are the steps?
Thank you
2007-03-06
11:02:07
·
3 answers
·
asked by
Ellen M
1