View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mja mja is offline
external usenet poster
 
Posts: 15
Default quickest way to copy information to several cells in a very la

I have an employee name in column A9 and need it copied form a1 to a7 and
then new mane in column A9 and need it copied into a10-a17 I need to do this
for over 2000 employees.
some of the name have to copied to 5 or 6 cells and other have to copied to
to 8 or 9 cells.
There is information in column b that has to stay with the corecct employee
when I apply a filter.
Thanks

"raypayette" wrote:


Use the macro recorder to write the code for a few operations. Then you
can edit the macro to complete all your data.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563697