title: Displaying a portion of a table in a separate worksheet
body: <p>On my first worksheet in the workbook, I have a large table with multiple columns and rows (roughly a 1000 rows and 20 columns). </p>
  
  <p>I was wondering if it is possible to display part of this table in another worksheet in the workbook based on the criteria from one of the columns in the main table. </p>
  
  <p>To help explain this, I will use an example from the actual workbook.</p>
  
  <p>On worksheet 1 (called <em>General Employee Info</em> which is the main table), in Column A each row has a unique number identifying an employee (each employee has their own ID number). </p>
  
  <p>Column B holds their office location (a city/municipality). Column C holds the state the office is in. Column D holds their salary amount per year. </p>
  
  <p>There are multiple more columns with this type of employee information, which needs no further explanation.</p>
  
  <p><strong>My question is</strong>, can I label Sheet 2 in the workbook <code>"New York State"</code> and have that sheet display all the same information as Sheet 1 (all the same columns) but only display the employees that work in the state of New York? </p>
  
  <p>And then have another sheet labelled <code>"California"</code> and have only the employees that work in California on that sheet and so on... In other words, have a separate sheet for each state.</p>
  
  <p>It's essentially like filtering the main table using the State column to show only one state, but I want the results in a separate sheet instead of filtering the main table which holds all the information.</p>
  
  <p>I was thinking of using a pivot table in each new sheet, but am not sure that's the right approach. </p>
  
  <p>Is this possible? I hope I was clear in explaining the problem.</p>