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 first. Working out the priority is no problem, this is based on a formula elsewhere taking into account the working pattern.
So, each team (5 in total) has its own sheet in the workbook to track requests. Basically, I want the detail about the request to be pulled into the correct sheet based on the result in the "1st Priority" column (again, simple). However, I only want the detail to be pulled into the next sheet (2nd Priority) based on the result being no cover available ("NCA") returning from the first sheet.
Anything I try results in a circular reference, so I hope someone can help!!
3 Replies
- Creating a FILTER formula might be the way to go but it's difficult to draw one up without seeing the data or a scaled down sample workbook.
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.
