I understand how the copying of formulas works and how athe $ hepls to
maintain either the column or the row.

My question is can you reverse the procedure. Copying a formula to the right
will change the row number instead of the column number and copying down
will change the column.

Is this possible?

Here's an example:

=INDIRECT(CHAR(64+ROW(A1))&COLUMN(L1))

This is equivalent to =A12, but if you copy it across it will bring
values from A13, A14, A15 etc. If you copy it down it will bring
values from A12, B12, C12, D12 etc., but this will only work up to
column Z.

You can also look at the OFFSET function, and also TRANSPOSE.

Hope this helps.

Pete

On Jul 21, 4:04*pm, "Pete Provencher"
<pprovenc...@sitetechsystems.com> wrote:
> I understand how the copying of formulas works and how athe $ hepls to
> maintain either the column or the row.
>
> My question is can you reverse the procedure. Copying a formula to the right
> will change the row number instead of the column number and copying down
> will change the column.
>
> Is this possible?

Before someone does to a lot of trouble with this: why do you need it? Have
you looked at the TRANSPOSE function and/pr the Paste Special/Transpose
command?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Pete Provencher" <pprovencher@sitetechsystems.com> wrote in message
news:u0hbQM06IHA.4988@TK2MSFTNGP04.phx.gbl...
>I understand how the copying of formulas works and how athe $ hepls to
>maintain either the column or the row.
>
> My question is can you reverse the procedure. Copying a formula to the
> right will change the row number instead of the column number and copying
> down will change the column.
>
> Is this possible?
>

transpose did exacly what I needed. HTnk you.
"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:uW8iDi06IHA.4204@TK2MSFTNGP03.phx.gbl...
> Before someone does to a lot of trouble with this: why do you need it?
> Have you looked at the TRANSPOSE function and/pr the Paste
> Special/Transpose command?
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "Pete Provencher" <pprovencher@sitetechsystems.com> wrote in message
> news:u0hbQM06IHA.4988@TK2MSFTNGP04.phx.gbl...
>>I understand how the copying of formulas works and how athe $ hepls to
>>maintain either the column or the row.
>>
>> My question is can you reverse the procedure. Copying a formula to the
>> right will change the row number instead of the column number and copying
>> down will change the column.
>>
>> Is this possible?
>>
>
>

I looked at transpose and that is what I needed. Thank you.
"Pete_UK" <pashurst@auditel.net> wrote in message
news:bf61ec28-e01e-4737-900d-50ec2ef51b44@m36g2000hse.googlegroups.com...
Here's an example:

=INDIRECT(CHAR(64+ROW(A1))&COLUMN(L1))

This is equivalent to =A12, but if you copy it across it will bring
values from A13, A14, A15 etc. If you copy it down it will bring
values from A12, B12, C12, D12 etc., but this will only work up to
column Z.

You can also look at the OFFSET function, and also TRANSPOSE.

Hope this helps.

Pete

On Jul 21, 4:04 pm, "Pete Provencher"
<pprovenc...@sitetechsystems.com> wrote:
> I understand how the copying of formulas works and how athe $ hepls to
> maintain either the column or the row.
>
> My question is can you reverse the procedure. Copying a formula to the
> right
> will change the row number instead of the column number and copying down
> will change the column.
>
> Is this possible?

You're welcome.

Pete

On Jul 21, 4:55*pm, "Pete Provencher"
<pprovenc...@sitetechsystems.com> wrote:
> I looked at transpose and that is what I needed. Thank you