| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell to sheet
I have various tabs example one named HGI I want to have a formula that will look at cell B1 of a sheet i specify in a cell example report page cel A1 = HGI I want cell A2 to look at cell B1 of the sheet that is named in A1 -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=565543 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell to sheet
ceemo wrote: I have various tabs example one named HGI I want to have a formula that will look at cell B1 of a sheet i specify in a cell example report page cel A1 = HGI I want cell A2 to look at cell B1 of the sheet that is named in A1 Hi ceemo Try this in A2: =INDIRECT(ADDRESS(1,2,,,A1)) Regards Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell to sheet
If A1 contains the name of the sheet, you can use this to return the value in
x99 of that sheet. =indirect("'" & A1 & "'!x99") ceemo wrote: I have various tabs example one named HGI I want to have a formula that will look at cell B1 of a sheet i specify in a cell example report page cel A1 = HGI I want cell A2 to look at cell B1 of the sheet that is named in A1 -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=565543 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell to sheet
nice thanks alot for the tip. Will it alo work in an offset function when reffering to a starting cell or selection column -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=565543 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell to sheet
Will it alo work in an offset function when reffering to a starting cell or selection column -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=565543 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell to sheet
What happens when you tried it?
ceemo wrote: Will it alo work in an offset function when reffering to a starting cell or selection column -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=565543 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| if and then formula | Excel Worksheet Functions | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Linear Mode
