Replacing multiple data from one worksheet to another?

S

Simon L

Ok lets try and explain what I want to do :confused:

I have a worksheet with some publication data in. Column A has th
email address in so [email protected] may show up 10 times becaus
he has 10 publications.

In another worksheet (in the same file) I have a key of email addresse
and Staff ID numbers. So [email protected] has a staff ID of 2468
What I need to do is replace the email address in the publication
worksheet with the Staff ID numbers in the key worksheet.

Any help greatly appreciated?? :
 
D

Dave Peterson

How about just inserting a new column (adjacent to the email addresses) and use
=vlookup() to return the staff id in that column.

You could even hide the email address column (or convert the formulas to values
and delete the original column).

Debra Dalgleish has some nice instructions for =vlookup() at:
http://www.contextures.com/xlFunctions02.html
 
A

aaron.kempf

yeah.. here is an idea..

instead of
a) copying data between sheets a zillion times
b) havnig files that are too large
c) having multiple copies of the same data (probably of having
differences between different copies is pretty high)

you shoud

1) keep your DATA in a DATABASE
2) report on your DATA using Views and Sprocs
3) use a real reporting program like crystal or access instead of
creating the report by hand every week
 
Top