I want to build a formula where I can get the last cell data in a row.
A B C D E
John 15 20 33
Lee 12 38 49
So I want build a formula in Column H where I can get the last cell amount for the row.
How I can do it and one more thing is there anyway where I can copy 20 sheets data and paste in one sheet without copying individually.