View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
opieandy opieandy is offline
external usenet poster
 
Posts: 32
Default Best Way to Pull Data from Other Sheets

I have 20 sheets of data that are formatted similarly. On the first sheet,
I want the user to select one of the 20 sheets and have Excel pull in a range
of data from that sheet.

What is the best way to allow for user input to select the sheet?