software

...10 rows of 8 cells

Any ideas

Many thanks

Beatrice--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543812Copy the range and Paste Special select the quot;Transposequot; check box
--
Thanks for your help -
Joe Macquot;beatrice25quot; wrote:

gt;
gt; ...10 rows of 8 cells
gt;
gt; Any ideas
gt;
gt; Many thanks
gt;
gt; Beatrice
gt;
gt;
gt; --
gt; beatrice25
gt; ------------------------------------------------------------------------
gt; beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
gt; View this thread: www.excelforum.com/showthread...hreadid=543812
gt;
gt;


Thanks but that only gives me one row of 80!!!--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: www.excelforum.com/member.php...oamp;userid=34235
View this thread: www.excelforum.com/showthread...hreadid=543812
This gives one row of 80 cells, I want 10 rows of 8 cells--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543812One option is create a first row of formulas with =A1, =A11, =A21, ..., =A71,
and copy/paste on the 10 rows.

Hope this helps,
Miguel.

quot;beatrice25quot; wrote:

gt;
gt; ...10 rows of 8 cells
gt;
gt; Any ideas
gt;
gt; Many thanks
gt;
gt; Beatrice
gt;
gt;
gt; --
gt; beatrice25
gt; ------------------------------------------------------------------------
gt; beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
gt; View this thread: www.excelforum.com/showthread...hreadid=543812
gt;
gt;

enter quot;a1quot; in B1;
enter quot;a9quot; in C1;
drag across to create a1 to a73;
drag down to complete a1 to a8, a9 to a16, etc
replace ALL quot;aquot; with quot;=aquot;

quot;beatrice25quot; gt; wrote
in message ...
gt;
gt; ..10 rows of 8 cells
gt;
gt; Any ideas
gt;
gt; Many thanks
gt;
gt; Beatrice
gt;
gt;
gt; --
gt; beatrice25
gt; ------------------------------------------------------------------------
gt; beatrice25's Profile:
www.excelforum.com/member.php...oamp;userid=34505
gt; View this thread: www.excelforum.com/showthread...hreadid=543812
gt;

You are a star. Was not quite right but gave me the idea. I did not know
you can replace with = and effectively turn text into a formula.

thank you very much
B--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543812OR ... with your data in A1 to A80,
You could simply enter this formula *anywhere*,
And drag across 8 columns,
And then drag down 10 rows:

=INDEX($A$1:$A$80,8*ROWS($1:1)-7 COLUMNS($A:A)-1)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;beatrice25quot; gt; wrote
in message ...

You are a star. Was not quite right but gave me the idea. I did not know
you can replace with = and effectively turn text into a formula.

thank you very much
B--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile:
www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543812

Hi RD,

Thanks this looks like a good formula and an even better way to go

b--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543812Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;beatrice25quot; gt; wrote
in message ...
gt;
gt; Hi RD,
gt;
gt; Thanks this looks like a good formula and an even better way to go
gt;
gt; b
gt;
gt;
gt; --
gt; beatrice25
gt; ------------------------------------------------------------------------
gt; beatrice25's Profile:
www.excelforum.com/member.php...oamp;userid=34505
gt; View this thread: www.excelforum.com/showthread...hreadid=543812
gt;