|
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? |
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 |
| All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com