| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reading Cells In another worksheet
I think I am approaching this wrong way and their might be an easier way any
help is appreciated. I am trying to have a cell return a value from an adjacent tab within the same workbook. EX: Cell A1 contains the title of another worksheet, within the same file (workbook) In cell B2 I want it to return the value (number) located in cell D2 from the tab name defined in cell A1 I tried this but for some reason only get an error after entering it into the cell: =ActiveCell.Range(A1).value2.D2 Is this correct? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reading Cells In another worksheet
Maybe
=indirect("'" & A1 & "'!" & "D2") or maybe the suggestion at your other post???? mike wrote: I think I am approaching this wrong way and their might be an easier way any help is appreciated. I am trying to have a cell return a value from an adjacent tab within the same workbook. EX: Cell A1 contains the title of another worksheet, within the same file (workbook) In cell B2 I want it to return the value (number) located in cell D2 from the tab name defined in cell A1 I tried this but for some reason only get an error after entering it into the cell: =ActiveCell.Range(A1).value2.D2 Is this correct? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reading Cells is the same workbook different tab | Excel Discussion (Misc queries) | |||
| Creating a text string by reading content in multiple cells | Excel Worksheet Functions | |||
| Reading a worksheet from a specified workbook | Excel Worksheet Functions | |||
| worksheet protection reading | New Users to Excel | |||
| Trying to enlarge tab size on worksheet for easier reading | Excel Discussion (Misc queries) | |||
Linear Mode
