Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Scenario:
1. First line is a header 2. Remaining lines are data 3. Need to make sure the number of data records is even by adding a value to the last row +1, column D of "Trash" if the number of records is odd 4. Swap every two rows of data including the row with "Trash" (i.e. swap rows 2 and 3, swap rows 4 and 5, 6 and 7, etc.) Ideally, the macro would keep the original file as is and create a second file with the operations performed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I swap data in columns and rows around? | New Users to Excel | |||
How to swap the contents rows and columns in a spreadsheet? | Excel Worksheet Functions | |||
Excel should let you select 2 rows, right click, and SWAP them | Excel Worksheet Functions | |||
swap rows and columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) |