Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose columns to rows with spaces dougaf Excel Discussion (Misc queries) 4 May 31st 07 04:46 PM
Copying cells from varying rows annettek Excel Discussion (Misc queries) 2 May 25th 07 02:51 PM
How do I count cells with text but ignore cells with spaces? Husker87 Excel Discussion (Misc queries) 2 September 21st 06 12:31 AM
Macro that double spaces rows for an entire worksheet? glaves123 Excel Discussion (Misc queries) 1 November 6th 05 03:42 AM
How do you automatically put spaces between rows in a lengthly w. marvaod Excel Discussion (Misc queries) 2 March 19th 05 12:28 AM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"