| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value based on selection from drop box
I have a worksheet with a drop box list, containing names of sheets (B2). I
want the cells in B3:F4 to carry a duplicate of the same cells from that sheet name. Can anybody help me with a formula or macro for that purpose? TIA Esra |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value based on selection from drop box
Esra,
I think you could use either of these in cell B3: =INDIRECT("'" & $B$2 & "'!" & ADDRESS(ROW(A3),COLUMN(B2))) or =INDEX(INDIRECT("'" & $B$2 & "'!$A:$F"),ROW(),COLUMN()) Then copy, and paste in B3:F4. HTH, Bernie MS Excel MVP "Esra" wrote in message ... I have a worksheet with a drop box list, containing names of sheets (B2). I want the cells in B3:F4 to carry a duplicate of the same cells from that sheet name. Can anybody help me with a formula or macro for that purpose? TIA Esra |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value based on selection from drop box
Helps a great deal, thank you
Esra "Bernie Deitrick" wrote: Esra, I think you could use either of these in cell B3: =INDIRECT("'" & $B$2 & "'!" & ADDRESS(ROW(A3),COLUMN(B2))) or =INDEX(INDIRECT("'" & $B$2 & "'!$A:$F"),ROW(),COLUMN()) Then copy, and paste in B3:F4. HTH, Bernie MS Excel MVP "Esra" wrote in message ... I have a worksheet with a drop box list, containing names of sheets (B2). I want the cells in B3:F4 to carry a duplicate of the same cells from that sheet name. Can anybody help me with a formula or macro for that purpose? TIA Esra |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell value based on selection from drop box
Hi,
Here is another approach: =INDIRECT(B2&"!"&CELL("address")) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Esradekan" wrote: Helps a great deal, thank you Esra "Bernie Deitrick" wrote: Esra, I think you could use either of these in cell B3: =INDIRECT("'" & $B$2 & "'!" & ADDRESS(ROW(A3),COLUMN(B2))) or =INDEX(INDIRECT("'" & $B$2 & "'!$A:$F"),ROW(),COLUMN()) Then copy, and paste in B3:F4. HTH, Bernie MS Excel MVP "Esra" wrote in message ... I have a worksheet with a drop box list, containing names of sheets (B2). I want the cells in B3:F4 to carry a duplicate of the same cells from that sheet name. Can anybody help me with a formula or macro for that purpose? TIA Esra |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count based on selection from drop down list | Excel Worksheet Functions | |||
| Based on Drop-Down Selection go to that Section on Sheet | Excel Discussion (Misc queries) | |||
| Hide row(s) based on drop down selection | Excel Discussion (Misc queries) | |||
| Change row colour based on the drop down selection | Excel Discussion (Misc queries) | |||
| Drop Down Lists - assign a value based on selection | Excel Worksheet Functions | |||
![Esra[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
