My workbook's first worksheet features a sizable table with numerous columns and rows (roughly 1000 rows and 20 columns).
I was wondering if it was possible to use the criteria from one of the columns in the main table to display a portion of this table in another worksheet within the workbook.
I'll use a real workbook example to help illustrate this.
Each row on worksheet 1, which is the main table and is titled "General Employee Info," contains a distinct number that identifies an employee in Column A. (each employee has their own ID number).
Their office location (a city or municipality) is listed in Column B. The location of the office is indicated in Column C. Their annual pay is listed in Column D.
There are numerous additional columns that provide this kind of employment information, which is self-explanatory.
My question is, can I label Sheet 2 in the workbook "New York State" 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?