Hello,
Below is a formula someone helped and resolved the problem in
column B. When I copy and paste into either C6,F6, and G6 it doesn't
go down the 6 cells. Please help.


=INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))


Put in B7 and copy down through B37.

No one who didn't read your earlier post will understand what you are trying
to do.

In B6, you had a formula that pulls the value from E2 on another sheet. In
B7 through B37, you have a formula that pulls values from a cell in the same
column that B6 references, but 6 rows down each time.

If you copy the formula in B6 to C6, it will refer to column F on the other
sheet. You must adjust the second argument of the ADDRESS function when you
copy the formula from B7 to C7. The second argument of the ADDRESS function
is the column number: 5 is column E, 6 is column F, etc. This will not change
automatically as you copy the formula to other columns; you have to edit it.

Hope this helps,

Hutch

"Ric" wrote:

> Hello,
> Below is a formula someone helped and resolved the problem in
> column B. When I copy and paste into either C6,F6, and G6 it doesn't
> go down the 6 cells. Please help.
>
>
> =INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
>
>
> Put in B7 and copy down through B37.
>
>

On Feb 21, 6:23*pm, Tom Hutchins
<TomHutch...@discussions.microsoft.com> wrote:
> No one who didn't read your earlier post will understand what you are trying
> to do.
>
> In B6, you had a formula that pulls the value from E2 on another sheet. In
> B7 through B37, you have a formula that pulls values from a cell in the same
> column that B6 references, but 6 rows down each time.
>
> If you copy the formula in B6 to C6, it will refer to column F on the other
> sheet. You must adjust the second argument of the ADDRESS function when you
> copy the formula from B7 to C7. The second argument of the ADDRESS function
> is the column number: 5 is column E, 6 is column F, etc. This will not change
> automatically as you copy the formula to other columns; you have to edit it.
>
> Hope this helps,
>
> Hutch
>
>
>
> "Ric" wrote:
> > Hello,
> > * * Below is a formula someone helped and resolved the problem in
> > column B. *When I copy and paste into either C6,F6, and G6 it doesn't
> > go down the 6 cells. *Please help.
>
> > =INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
>
> > Put in B7 and copy down through B37.- Hide quoted text -
>
> - Show quoted text -

Thanks again for the help!