New to this website.
Is it possible to create an array on one worksheet and pull data from a different sheet?
I am trying to review monthly data defect types which are on one tab. I have created a review on the same sheet in order to get the correct information. however when I do a filter the review section is hidden. I would like to move the array formulas to a different review tab for easier data review.
The file is attached for your review.
Bookmarks