Linking cell through variable
Although this is simple task i stuck up with these
for eg. cell A1= 5 (variable), A5=10 and i need in in cell b1= A(variable of a1) in this case it is A5 i.e 10 How to write formula or macro for this. |
Linking cell through variable
On May 5, 8:46*am, ezil wrote:
Although this is simple task i stuck up with these for eg. cell A1= 5 (variable), A5=10 *and i need in in cell b1= A(variable of a1) * * * * * in this case it is A5 i.e 10 How to write formula or macro for this. Take a look at the INDIRECT function. B1 = INDIRECT("A" & A1) Chris M. |
All times are GMT +1. The time now is 09:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com