You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
-
they won't allow us to setup macro enabled workbooks
Surely it becomes their (the clients) problem then, not yours?
rhb-
If only!
This project is so messed up that I can't even find it funny any more-
Extracting data from their software, messing with it in excel to create reports that can then be shared via email in excel files. THEIR SOFTWARE HAS A COMPREHENSIVE (AND PRETTY DECENT) IN APP REPORTING MODULE ALREADY.
Paying the rent and all that...
In other news just plugged the sheets into Power BI and it has a table tool were you select the relevant columns which is just what I was looking for.
salmonchild
My colleagues are on a client site and they won't allow us to setup macro enabled workbooks unfortunately- hence the pain.