I've been thinking, maybe I could read the values into an array and the
reproduce them on all the sheets like that?

Am I way off track here?


or maybe, If i put a matching function in all the sheets cells where
need to name and tried to match fill the gap that way.... this coul
work as on the list initial sheet i have the peoples name and in th
cell to the right i have the names of the sheets which have bee
created to hold the names..... but how can i match something useing
sheet name

--
Hru4
-----------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...fo&userid=2489
View this thread: http://www.excelforum.com/showthread.php?threadid=47140