macro

[Guest]

I am trying to write a macro
I have a list of names that may very each month but no more than 280 names.
Names may be added and deleted. On a separate tab I want the names to carry
over along witht information to the right and then be sorted. I get as far
as to get the names on the second sheet with the information when it goes to
sort somehow when the name carried over if there was no name then it made it
a 0 then when it sorts the 0 are at the top. How can I solve this problem.
Thanks
Cheyenne

 

[Guest]

check to see if there are formulas in the cells you are copying. You
probably need to perform a paste special, values only