To insert the value from the tab...
I know in order the insert a value from another cell we type =(the cell
number). What if I want the value from the tab (by default, they is sheet 1, sheet 2,....). for example, If i rename the tab as 123, and i want my sheet 1 cell A1 to have the tab value (hence 123), what should i do? |
Take a look he
http://www.mcgimpsey.com/excel/formu..._function.html In article , ash wrote: I know in order the insert a value from another cell we type =(the cell number). What if I want the value from the tab (by default, they is sheet 1, sheet 2,....). for example, If i rename the tab as 123, and i want my sheet 1 cell A1 to have the tab value (hence 123), what should i do? |
All times are GMT +1. The time now is 08:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com