Mac Forum / Applications / Excel / January 2007

hi again,

Question no1.

how can i create a macro to check any duplicated number within a range of
numbers .(i.e- column A- AZ)

requirement- to be checked right through out the work when ever someone
entering a new number.

question no-02,

i need to get a cell's value(which is text and assinged as a heading for a
column)
to another cell which is in worksheet2. this should work if only the
condition is true. e.i- worksheet1;column a,1- heading is "teamA ". and  
under the team A
listed numbers are 5,8,10. , worksheet 2 has a table for staff id numbers as
1-100.
and need to show the team name in the ajoining column (b). actually in
worksheet i has few team names from A to K and different staff i.ds would be
listed.

hope you got my point clearly.
is there a function for this or have we to create a macro for this.pls
give me the full details on how i can overcome this question.