To insert the value from the tab...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare values and place corresponding value in another sheet 3
macro or formula to paste values from one tab to another 1
Creating a tab name by entering a cell value in a different worksh 1
sharing cell values 10
vlookup with 2 conditions? 2
How to search a spread sheet for a value and return the adjacent v 4
Average using Sumproduct or .... 7
Excel, assign cells in multiple worksheets from one sheet 1

Back
Top