3 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

What is the easiest way to enter Team Up calendar data into excel spreadsheets.

Our take

Managing event details in a hotel can be time-consuming, especially when transferring data from Team Up calendars to Excel operational setup sheets. These sheets are essential for streamlining communication among staff, ensuring everyone is informed about meeting requirements. By exploring the possibility of importing CSV files directly into Excel, you can simplify this process. This approach could automate data entry, allowing you to focus on enhancing guest experiences instead of getting bogged down in manual tasks. Discover how to make your workflow more efficient today.

I work in a hotel where a small, very time consuming part of our job is creating operational set up sheets for meetings and events that happen in the hotel. These sheets are again a very time consuming and tiny sliver of a lot of the FOH staffs daily to do list, so most of the work falls on me (basically OP will do it, so why should we :)

Our operations sheets are created using a bog standard excel spreadsheet, where all details can be entered as per the needed set up / catering / staff support i.e. Technological Requirements, Lunch or Dinner options, Catering Requirements etc. These are usually manually transferred from Team Up, which along with other calendars serves as the back end, meeting and event management system as it allows for all important details to be entered and clearly displayed so that every area in the hotel, be it the kitchen, catering staff, maintenance staff, porter staff or reception and FOH are able to see where something is booked, for how long and what is needed, along with essential contact and billing details.

Our sheets are extremely simple, basically currently just serving as an easier to use word document.

The op sheets serve the importance that, on a basic level, we need to have a simple, quick to read, easy to understand sheet for all requirements listed for any meeting, conference, event, function or meal, so that nobody in the hotel is ever missing and info. These sheets are a clean, simplified version of the Calendar, and hold all essential data.

The sheets are usually also sent to corporate clients who wish to present this summary to all presenters and hosts for the event or meeting / training etc.

What I want to know is, bar culling data manually from what has been entered into the calendar, then manually entering all the data, is there anyway that a CSV file can be read, filtered and the filtered items can be entered into the different sections of these sheets?

EXAMPLE:

Company X Regional Compliance AGM

Team up: Meeting set up for 20 attendees, 2 presenters and 1 monitor.

Excel: MTG x 20, TT x 2 + 1

EXAMPLE 2:

Team up: Tea / Coffee and an array of sandwiches and finger food to be served

Excel: T/C/Sands + FF

More or less, is there a way to set up a pattern recognition for all relevant data, to make it that a CSV file can be imported into the sheet, information is filled out without manual culling and it allows for all info to flow effortlessly between both places?

I have googled, begged AI to help and also tried finding something similar on this sub but its genuinely very hard to properly explain without writing out a post. Thank you in advance :D

submitted by /u/LiveGur2149
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Related Articles

Tagged with