Formatting CSV Daily For Printing
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]
Want to read more?
Check out the full article on the original site