| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping Paste Special Value Transpose
I am trying to create a macro that will loop through list of items containing
4 columns and Paste Special Values Transpose into a Single column on a blank worksheet. My problem is that Col C & D are blanks, so I need to step down 4 rows with each paste. PartNo-Qty-Blank1-Blank2 I need it to be: PartNo Qty Blank1 Blank2 PartNo Qty Blank1 Blank2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose, Paste Special | Excel Discussion (Misc queries) | |||
| Paste Special / transpose | Excel Discussion (Misc queries) | |||
| When I special paste and transpose.... | New Users to Excel | |||
| Paste Special Transpose | Excel Programming | |||
| Need help with Transpose paste special | Excel Programming | |||
Threaded Mode
