Filter with indirect function

Hi all,

can someone please assist with the dashboard page of the attached?

It's a dashboard built off the other sheets.

I've been using indirect function to make it look at the correct month of the forecast.

I'm now trying to update the formulae for C68, currently it filters based on column B of the baseline tab.

I want it to filter on column B of the current month tab, e.g. use the indirect function & look at cell B2 of dashboard tab.

For some reason my indirect won't work when I'm using filter.

Alternatively, if someone had feedback on a better way to do this I'm open to all suggestions.

The idea is that every line of the PM's forecast can be tracked against what the originally forecast to see variances or changes throughout the year.

We originally had it picking up info from the baseline tab, but as they may add new lines throughout the year we want it to filter based on the current month tab.

Kind regards

How about

Formula:

Please Login or Register  to view this content.

You are a wizard - thank you.

Kind regards

You're welcome & thanks for the feedback.