| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving data from 3 columns to next 3
I have a long list of data in columns A, B & C. The data is sorted by column C and contains the number 1 for so many rows, and then 2 and so on. What I need to do is cut and paste the data from columns A, B & C to E, F & G when C changes to 2 and then H, I & J when it changes to 3 and so on. How can I automate this. -- macke ------------------------------------------------------------------------ macke's Profile: http://www.excelforum.com/member.php...o&userid=32445 View this thread: http://www.excelforum.com/showthread...hreadid=522215 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving data from row to columns | New Users to Excel | |||
| Moving data between columns | Excel Discussion (Misc queries) | |||
| moving duplicate data in rows to columns with same name | Excel Discussion (Misc queries) | |||
| IF statements and moving data to different columns | Excel Worksheet Functions | |||
| Moving data from multiple columns | Excel Programming | |||
Linear Mode
