Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a reference to lookup and insert a name | New Users to Excel | |||
insert picture | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |