| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving rows in Macro/If statements
Trying to figure out the best way to use an "IF" statement in a macro that
will move data down to the next row. Have a spreadsheet that has the following columns: Name-Address-City-State-Child1name-Child1DOB-Child1age-Child1sex-Child2name-Child2DOB-Child2age-Child2sex-Child3name-Child3DOB-Child3age-Child3sex. The first 4 columns will remain the same. However, if the parent has several children, the formula/macro can identify the columns and insert them below, matching the columns above. So now the data should show: Name-Address-City-State-Child1name-Child1DOB-Child1age-Child1sex Child2name-Child2DOB-Child2age-Child2sex Child3name-Child3DOB-Child3age-Child3sex |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO for moving rows from one worksheet to another | Excel Discussion (Misc queries) | |||
| Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
| Macro for Moving rows | Excel Discussion (Misc queries) | |||
| IF statements and moving data to different columns | Excel Worksheet Functions | |||
| Macro for moving rows? | New Users to Excel | |||
Threaded Mode
