View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jdpf jdpf is offline
external usenet poster
 
Posts: 7
Default 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?