View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Titus Doug Titus is offline
external usenet poster
 
Posts: 1
Default Need help copying cells into rows with spaces between

I'm trying to copy the contents from rows but need it to show
verticaly.

I need to reference cells by an increment of 1 but because of the
spaces between rows when I copy it increments by 4, or 5, or whatever
the distance is between them.

For example, I need lines 1, 5, 9... to show cells A1, A2, A3... and
not A1, A5, A9...

In very general terms I'm trying to get it in this format:

References A1
References B1
References C1
References D1
References A2
References B2
References C2
References D2

Thanks in advance for any help or ideas.