Forum Discussion
Solved
How to create formula for cell Value from cell in other sheet by input row Number ?
I want user only in put row number to start to Calculate data -> How to create formula for cell Value from cell in other sheet by input only row Number ? Sheet A : Have data in many rows Row ...
=SUM(INDIRECT("'"&C1&"'!"&"C"&D1&":"&"C"&E1))Is this what you are looking for? In sheet A you can dynamically enter the row number in cells D1 and E1.
=SUM(INDIRECT("'"&C1&"'!"&"C"&D1&":"&"C"&E1))Is this what you are looking for? In sheet A you can dynamically enter the row number in cells D1 and E1.
- Yes Thank you very much -> I can do it now by change some formula like this
'=INDIRECT($D$1&"!"&"B"&$D$2)
$D$1 = Sheet A
B = Column B
D2 = Start row
and next row i change Formula to
'=INDIRECT($D$1&"!"&"B"&$D$2+B12) -> for Copy to 999 row
B12 = Column B row 12 i'm runing 1 , 2 , 3 , 4, to next row
Now i can do it
Thank you very much 🙂
🙂
