Excel - Using input to access different worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Consulting Joan said:
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...
Click to expand...


You might have better luck asking your question at
news://news.microsoft.com/microsoft.public.excel
 
Back
Top