•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formatting CSV Daily For Printing
Our take
Managing daily room bookings efficiently is essential for your circulation team. To streamline the process of formatting CSV reports into a print-friendly table, consider automating the task with a macro. This solution can convert the CSV data into a structured table, adjust row heights for handwritten notes, and set the table width for landscape printing on letter paper.
Hello, My circulation team gets a CSV report every morning that shows all of our room bookings for the day and allows them to plan out accordingly. I was trying to figure out which method would be best to help them automate formatting the CSV into a nice print-friendly table that they can print out for the different info desks (they like their written stuff rather than keep it digital). I would also need to add a column called Notes (if this causes complications I can add another column into the table export and use that)
Was wondering if setting up a macro to automatically convert the data into a table, set the row height to a predetermined size so that the Notes column can be written into by hand if they need to throughout the day, and then set the table width to work for a landscape printout on letter paper would work. Or would some other method be better?
Sample of the CSV below: EDIT: reddit table wasn't working so here's a paaster link https://paaster.io/69b42fdc713738761c21df85#XVkZmT-XxPmjHDuhTSdXD2EbW1Ct1elx2ZOi7XvpjV8
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need macro advice! Saving longer numbers as strings to show all the charactersDesktop, Excel 365 Build 19929.20106 Click-to-Run, Beginner We have a macro that generates new files using a list of data. Sometimes that data is completely numerical with over 15 digits. Excel keeps reformatting these numerical entries using scientific notation, which screws up the output files. Right now I have to manually check the output files and reformat the affected ones so that all then hidden characters are shown. Can someone please advise on how I can update the macro to automatically convert these numbers into strings that show all the characters? The data is of variable length, but I'm pretty sure it's always under 20 characters. This problem only affects one cell of the output file. Everything else is generated without issue. It's basically the problem of "how do I make Excel macro copy-paste the entire FedEx tracking number correctly" but the data isn't consistently 16 characters and is frequently alphanumeric. EDIT: I'm open to even stupid and booleg solutions like "add a hidden text character before transferring the data" to force this to work. The output files are basically just printables. I just don't know anything about macros and do not have time to learn. submitted by /u/Umklopp [link] [comments]
- What is the easiest way to enter Team Up calendar data into excel spreadsheets.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]