Forum Discussion
Help!
Okay so I seem to be going round in circles (literally). I have an 'Input Sheet' to track holiday requests, when this request goes in, it has to be prioritised into which team gets asked to cover it ...
Patrick2788 thanks for the reply, the problem with the filter function is that it will be filtering 3000 rows between 5 separate sheets so it slows the sheet down significantly. I will try to get a sample made up to attach at some point.
If you have access to VSTACK, you could 3D stack then FILTER.