I'm new with SharePoint but I feel like I'm catching on pretty well. I'm creating a new page layout and I plan to put a list webpart in the right column. The list webpart will be filtered using the current view settings on a column called "Functional Area". Each page that will use this page layout has a value in the functional area column. Right now I have manual typed in the functional area into the current view so for instance it is set to "Show the items when column -> Functional Area -> is equal to -> "Testing".
Here is my question and what makes it complicated. I would like the webpart current view filter to automatically pull in the value for "Functional Area" of the page that the person is on and have the list webpart only show pages that has the same value in the functional area column as the current page being viewed.
Is this possible? I'm asking because if not than I have to tell each manager to go into the webpart and change the filter value when they create a page for their group and I don't want them to have to do that.
Any help would be greatly appreciated.