Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continued issues
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continued issues
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continued issues
On Feb 21, 6:23*pm, Tom Hutchins
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average With < Continued | Excel Worksheet Functions | |||
Median continued | Excel Discussion (Misc queries) | |||
If then statement continued! | Excel Discussion (Misc queries) | |||
two-variable calculations continued ... | Excel Discussion (Misc queries) | |||
continued help needed | Excel Programming |