I've been thinking, maybe I could read the values into an array and then
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 i
need to name and tried to match fill the gap that way.... this could
work as on the list initial sheet i have the peoples name and in the
cell to the right i have the names of the sheets which have been
created to hold the names..... but how can i match something useing a
sheet name?


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471460