Hi,
I am trying to implement a 'plug and play' approach to scheduling in our office to improve efficiency in the office and avoid everyone always making a new schedule etc.
When creating a schedule I am trying to get the worksheet 'database' to find windows / or doors on particular layers which all start with 'P_'... 00,01,02,04 etc. As we all know we can choose to find from a particular layer but I want to input an IF formula, where it tells the database to find windows and doors on all layers starting with 'P_'. Any ideas how this can be achieved, at the moment it appears that you can only select particular layers.
Thanks
Gavin