Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
quickest way to erase error cells | Excel Programming | |||
How do I copy a LARGE selection of cells from Excel to powerpoint? | Excel Discussion (Misc queries) | |||
Quickest way to copy then Paste Special-Values in place? | Excel Programming | |||
What is the quickest way to copy codes in Sheets? | Excel Programming | |||
What is the quickest way to copy codes in Sheets? | Excel Programming |