Copying list values
 

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

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

Copying list values
 

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

--
Regards,
Tom Ogilvy


"Hru48" wrote in
message ...

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

Say into cell C3.

Any Ideas welcome

Cheers

Hayley


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

Copying list values
 

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


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

Copying list values
 

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