....results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

In D25 try the below formula and copy across...
=INDEX(9:9,COLUMN(A1)*5+1)

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

Perfect,
Thanks,

So many ways to achieve the same results, because with Lars' & Shane's
solutions also worked great.

Thanks again,

Steve

"Jacob Skaria" wrote:

In D25 try the below formula and copy across...
=INDEX(9:9,COLUMN(A1)*5+1)

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

Steve
Select all the cells in row 9 that you want to copy. Do this by first
clicking on F9. Then hold your Ctrl key down and select each of the rest of
the cells, K9, P9, U9. Now do Edit - Copy. Click on D25. Now do Edit -
Paste. Done. HTH Otto
"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

I have to update this weekly, so I wanted to automate it more, rtaher that
re-selecting the #'s aver week, and also may eventually end up with too many.

Thanks,

Steve

"Otto Moehrbach" wrote:

Steve
Select all the cells in row 9 that you want to copy. Do this by first
clicking on F9. Then hold your Ctrl key down and select each of the rest of
the cells, K9, P9, U9. Now do Edit - Copy. Click on D25. Now do Edit -
Paste. Done. HTH Otto
"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

Hi,
highlight everything in row 9, hit CTRL G, special, constants, leave only
numbers checked, OK, CTRL C, go to row 25 and press CTRL V

if this helps please click yes thanks

"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

This worked however I have other #'s in that row that I don't need, so I used
the other solutions.

Thanks,
Steve

"Eduardo" wrote:

Hi,
highlight everything in row 9, hit CTRL G, special, constants, leave only
numbers checked, OK, CTRL C, go to row 25 and press CTRL V

if this helps please click yes thanks

"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

This produced the same # when dragging across, but the other solutions worked
great.

Thanks
Steve

"T. Valko" wrote:

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

This produced the same # when dragging across

Hmmm...

Well, I can assure you that formula does exactly what you asked for and is
both robust and efficient.

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
This produced the same # when dragging across, but the other solutions
worked
great.

Thanks
Steve

"T. Valko" wrote:

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

You're right. Sorry, I must have did something wrong earlier, because it
works great now.

Thanks again

"T. Valko" wrote:

This produced the same # when dragging across

Hmmm...

Well, I can assure you that formula does exactly what you asked for and is
both robust and efficient.

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
This produced the same # when dragging across, but the other solutions
worked
great.

Thanks
Steve

"T. Valko" wrote:

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

Good deal! Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
You're right. Sorry, I must have did something wrong earlier, because it
works great now.

Thanks again

"T. Valko" wrote:

This produced the same # when dragging across

Hmmm...

Well, I can assure you that formula does exactly what you asked for and
is
both robust and efficient.

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
This produced the same # when dragging across, but the other solutions
worked
great.

Thanks
Steve

"T. Valko" wrote:

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

You must have mistyped the formula.
Check that you have written COLUMNS (not COLUMN)
Check that you have written $D25:D25 (not D25:D25 or $D25:$D25)

Hope this helps / Lars-Åke

On Mon, 14 Sep 2009 12:56:02 -0700, Steve
wrote:

This produced the same # when dragging across, but the other solutions worked
great.

Thanks
Steve

"T. Valko" wrote:

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

Yes, I did have columns, but I must have had something else wrong, because it
works great now.

Thanks for your patiencew.

Steve

"Lars-Ã…ke Aspelin" wrote:

You must have mistyped the formula.
Check that you have written COLUMNS (not COLUMN)
Check that you have written $D25:D25 (not D25:D25 or $D25:$D25)

Hope this helps / Lars-Ã…ke

On Mon, 14 Sep 2009 12:56:02 -0700, Steve
wrote:

This produced the same # when dragging across, but the other solutions worked
great.

Thanks
Steve

"T. Valko" wrote:

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D25:D25)*5-4)

Adjust for the correct end of range: $F9:$AZ9

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

On Mon, 14 Sep 2009 10:50:01 -0700, Steve
wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve


If you want a formula solution, try this in cell D25:

=OFFSET($F9,,5*(COLUMN()-COLUMN($D1)))

copy this across to the right as far as needed

Hope this helps / Lars-Åke

Perfect,
Thanks,

So many ways to achieve the same results, because Jacob's & Shane's
solutions also worked great.

Thanks again,

Steve


"Lars-Ã…ke Aspelin" wrote:

On Mon, 14 Sep 2009 10:50:01 -0700, Steve
wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve


If you want a formula solution, try this in cell D25:

=OFFSET($F9,,5*(COLUMN()-COLUMN($D1)))

copy this across to the right as far as needed

Hope this helps / Lars-Ã…ke

Hi,

And yet another solution

=OFFSET($F8,,COLUMN(A1)*5-5)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

On Mon, 14 Sep 2009 12:26:01 -0700, Shane Devenshire
wrote:

Hi,

And yet another solution

=OFFSET($F8,,COLUMN(A1)*5-5)

Shouldn't than be

=OFFSET($F9,,COLUMN(A1)*5-5)

which could be further reduced to

=OFFSET($A9,,COLUMN(A1)*5)

/ Lars-Åke

Perfect,
Thanks,

So many ways to achieve the same results, because Jacob's' & Lars'
solutions also worked great.

Thanks again,

Steve


"Shane Devenshire" wrote:

Hi,

And yet another solution

=OFFSET($F8,,COLUMN(A1)*5-5)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Steve" wrote:

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve