Skip to main content
edited tags
Link
Jean-François Corbett
  • 38.5k
  • 30
  • 142
  • 189
edited tags
Link
user2140173
user2140173
Source Link

Selecting a sheet from the value in a cell

Is it possible to select a sheet based on the value in the cell. For example

  Col_1      Col_2      Col_3

  gor         100        jan
  mack        60         jan
  john        40         mar---->this data
  ..... So on

Here am checking for persons who have below 50 hours and if they have 50 hours then i have to go to that sheet and mark them to represent them. here john has below 50 hours then i have to get the sheet name from the col_3 that's here March. I have to goto that mar sheet and mark them. My question is that. Is it possible to select or get a sheet name based on the value in a cell.