| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting non-adjacent data
I have a large list of names and addresses that when imported into excel
comes in without being in the proper columns (name, address, city, state, etc). To fix this I need to select and copy the data in every eighth row (A3, A11, A19, A27, etc.) and paste this into a name column. Is there a way to do this automatically without clicking on every cell individually? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for selecting non-adjacent cells | Excel Discussion (Misc queries) | |||
| Keyboard Navigation - selecting non-adjacent rows | Excel Discussion (Misc queries) | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| selecting adjacent cells | New Users to Excel | |||
| selecting non adjacent cells | Excel Worksheet Functions | |||
Threaded Mode
