Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP----Row cut and Paste
I have an Excel spreadsheet that contain several blocks of data. Eac
block contain a random number of rows but each row have a maximum o twenty columns. I need to transfer the data from each block and row by row by Cut an paste. There are many blocks and a macro is required. My majo difficulty is that the rows in one block must be transferred to single row, separated by a blank column, prior to pasting the next ro and so on. The next block should be paste into row two and repeat unti the entire blocks are transfered. An additional problem that migh arise is that if one block requires more that 256 column, then th additional row must be pasted on sheet two, or three if need. Any advice..... All are appreciated -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Macro to Paste to specific line, and continue to Paste each time on next row not over | Excel Programming |