quickest way to copy information to several cells in a very large

[Guest]

I have a very large sheet that has been generated by a different system and
converted to excel. In column A is employee name and in column b and c is
pertanant information that is coneteced to each employee. The employee name
is in A1 and the other information is in b2 - c6.
I need to sort this information in variuos ways and keep the pertanant
information correct with each employee. The next employee name is in a10 and
their info is in b11 - c15.
I have been using the copy past to put the name in each cell below to allow
me to sort the information, but the sheet is 33000 rows long so it takes for
ever and if I make a mistake the information is not correct for that
employee.
any help to automate this copying process would be greatly apperciated.
Thanks in advance

 

[raypayette]

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

 

[Guest]

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