| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Using input to access different worksheets
Is there a way in excel that you can enter a value and it will access the
approporiate worksheet. For example, I have worksheets labelled WS1, WS2 and WS3. If I enter a value of "1", I want it to pull the value from cell A2 of WS1, if I enter "2" it will pull the value of cell A2 from WS2 and so on... |
|
#2
|
|||
|
|||
|
Hi!
Assume you enter the value in cell A1: =IF(A1="","",INDIRECT("WS"&A1&"!$A$2")) Biff -----Original Message----- Is there a way in excel that you can enter a value and it will access the approporiate worksheet. For example, I have worksheets labelled WS1, WS2 and WS3. If I enter a value of "1", I want it to pull the value from cell A2 of WS1, if I enter "2" it will pull the value of cell A2 from WS2 and so on... . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook - Defining Access Rights | Excel Worksheet Functions | |||
| can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Hybrid Mode
