 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      A              B             C           D          E

1          XXX          7

2         DDD         3.5

3         BBB           2

4          JJJ             1.33

...

...

...

at Sheet B : Want user in put only Row number to be Value from row sheet A

For user

Sheet =      A

Row =        xx <- User  Input only row number  to Start for sum

At sheet B

cell C10 =SUM(C11:C999)

cell C11 Start Value

at cell C11 Start Value from Sheet A

=A!Bxx                 <- How to create formulas or Function like this requirement ?

=A!B(row xx+1)    <- How to create formulas or Function like this requirement ?

=A!B(row xx+2)

=A!B(row xx+3)

...

...

...

Thank you very much

2 Replies
best response confirmed by SomchaiSomjui2011 (New Contributor)
Solution

# Re: How to create formula for cell Value from cell in other sheet by input row Number ?

``=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.

# Re: How to create formula for cell Value from cell in other sheet by input row Number ?

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