Stuck with simple Excel problem, help

[nickinIT]

i have two sheets in excel
i have made macro that takes a name from one sheet and pastes it to another
i want to repeat this step with different names, the problem i have is that each time i change the name and run the macro it overwrites the last one
help
thnxs
Bob

 

[Juan Pablo González]

Can you post your existing code ? I'm not sure I follow what you want/need.