Pivot Table or Vlookup?

[KristenLehman]

Hello,

I have multiple tabs in my excel workbook. The first tab is a master issue tracker tab. It is constantly updated with new issues. The other two tabs are location tabs ie. town. For instance Hanover tab and Lebanon tab.

The master tab has many columns:
Issue
Issue Description
Department Location (Hanover or Lebanon)
Priority
Order Part
Part Description
Assigned to
Status
Notes

What I want to do is under the Hanover tab have all the Hanover issues automatically placed under this tab from the master tab and the same for the issues in Lebanon. And as I updated the master it automatically updates the Hanover and Lebanon tabs.

What is the best way to make this happen?

 

[duggie33]

If you are using Office 365, the FILTER function would likely work...

Please update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using, as the best solution often varies by version. Don’t forget to scroll down to save your changes.

Please provide some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data, allowing us to copy/paste it to our Excel spreadsheets to work with the same data you are. As of October 2023, the latest version is 2.1. Instructions on using this tool can be found here: XL2BB Add-in

Note that this board also has a "Test Here” forum. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Thanks,

Doug