Automatic Hotel P&L in Excel
I got assigned to build out an excel that will automatically cast any hotels P&L into my firms desired template. I’m aware of typical retrieving functions, however the hiccup lies in pulling line items that share the same name but are located in different categories (ie. Wages and Management; F&B department).
Any ideas or advice to get around building this out? 🙏🏼