Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set a formula, that add next cell reference in a Formula
I am populating value from another worksheet in form format using following
formula in a cell, let us say in A5 of current worksheet. =Data!E1 Now I want to have contents of worksheet "Data", cell E2 in cell A10 of current worksheet. Like that I want to keep using the incremental values for N number of times. How can I do that? = -- Gary You Will, You Can |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set a formula, that add next cell reference in a Formula
Gary
I'm not sure exactly what you are trying to do, but, I believe you will need to build your reference to the data worksheet in an INDIRECT formula. This formula in cell A10 of sheet2 will get the value from cell E2 of your data worksheet. =INDIRECT("data!e"&ROW()/10+1) I am not sure why this would be better than simply putting the formula =Data!E1 in cell A10 since you still don't have anything you an copy down but maybe it will get you started. The MOD function inside the INDIRECT funcion is often helpful as well when non contiguous but periodic cells on one sheet reference contiguous areas on another sheet. Good luck. Ken Norfolk, Va On Jul 17, 3:36*pm, Gary wrote: I am populating value from another worksheet in form format using following formula in a cell, let us say in A5 of current worksheet. * =Data!E1 Now I want to have contents of worksheet "Data", cell E2 *in cell A10 *of current worksheet. Like that I want to keep using the incremental values for N number of times. How can I do that? = -- Gary You Will, You Can |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set a formula, that add next cell reference in a Formula
Hi,
1. In A5 enter the formula =INDIRECT("Data!E"&ROW(A5)/5) 2. Highlight A5:A9 and drag the fill handle down as far as necessary. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gary" wrote: I am populating value from another worksheet in form format using following formula in a cell, let us say in A5 of current worksheet. =Data!E1 Now I want to have contents of worksheet "Data", cell E2 in cell A10 of current worksheet. Like that I want to keep using the incremental values for N number of times. How can I do that? = -- Gary You Will, You Can |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to reference a tab name within a cell by formula? | Excel Discussion (Misc queries) | |||
How do I get a cell reference into this formula... | Excel Discussion (Misc queries) | |||
Cell Reference in formula | Excel Worksheet Functions | |||
Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
cell reference in formula | Excel Worksheet Functions |