Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjusting rows versus columns for formulas
Not sure which group to post this under, so here it goes... again
I'm trying to find any way to adjust the row when I paste the formula in the next column or visa versa. I would be willing to use indirect references, but transposing my data would not work well as the data displays much better in the formats they are in. Ex. On first worksheet the data is like D E F G 2 | 25 50 39 27 .... and the second worksheet I'd like it to be G 3| Sheet1!D2 4| Sheet!E2 5| .... I don't really care what method I use to do this, but I'd rather not have to write a visual basic function to translate between the cells. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adjusting rows versus columns for formulas
=OFFSET(Sheet1!D$2,0,ROW()-3)
in G3 on sheet 2, per my other post in Worksheet Functions with same question. " wrote: Not sure which group to post this under, so here it goes... again I'm trying to find any way to adjust the row when I paste the formula in the next column or visa versa. I would be willing to use indirect references, but transposing my data would not work well as the data displays much better in the formats they are in. Ex. On first worksheet the data is like D E F G 2 | 25 50 39 27 .... and the second worksheet I'd like it to be G 3| Sheet1!D2 4| Sheet!E2 5| .... I don't really care what method I use to do this, but I'd rather not have to write a visual basic function to translate between the cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-adjusting Formulas | Excel Discussion (Misc queries) | |||
Copying and adjusting formulas | Excel Worksheet Functions | |||
Adjusting rows versus columns for formulas | Excel Discussion (Misc queries) | |||
Adjusting rows versus columns for formulas | Excel Worksheet Functions | |||
Adjusting columns | Excel Discussion (Misc queries) |