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