Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
quickest way to copy information to several cells in a very large
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
quickest way to copy information to several cells in a very large
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |