Copying list values

[Hru48]

Okdookie, I have a list of names on my first sheet (list) and severa
sheets after it (1,2,3,etc). How do I get the first value in the lis
to copy into sheet 1, the second value to copy into sheet two and th
third value down to go into the thrid etc..?

Say into cell C3.

Any Ideas welcome

Cheers

Hayle

 

[Tom Ogilvy]

i = 0
for each cell in selection
i = i + 1
cell.copy Worksheets(i).Range("C3")
Next

 

[Hru48]

I'm having trouble with this, should i declare the list range as a
variable?

 

[Hru48]

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