Displaying only certain data on second Excel sheet

Vote count:

0

I have an excel spreadsheet that has a 'Main View' sheet and a 'High Priority' sheet. In the 'Main View' sheet there is a column named Priority. In this column you can have three options, Low, Med, and High. The way I would like this to work is, if I have a row that has a High Priority I would like to display the entire row details in the 'High Priority' tab automatically.

Here is an example of how the data looks.

"Ticket Number" | "Description" | "Priority"
123             | Test case     | Low
223             | Client Issue  | High
345             | System Down   | High
456             | Phone down    | Low

The data I would like to automatically transfer over to the next sheet is the High Priority issues.

I tried using Vlookups and a filter to do this, but the problem I am having is if I add a new High Priority issue to the 'Main View' it does not populate in the 'High Priority' sheet.

I have a user who isn't familiar with programming, so I am trying to avoid doing this in VBA - I have a solution if we were going to do it this way.

Please let me know if there is a way to handle what I want in Excel and not VBA.

asked 40 secs ago

John Janssen

76