Forum Discussion
Automating a report with pre-existing tables and charts
Posting this again, this time with examples to hopefully help you all answer the question. I will attach two excels. The first one is an example of what I fill out every so often (Labelled: Template ...
I gotcha! I do not know how to convert the current tables on the template into a structured table, but I will be finding a YouTube video to help! Lol. I wish I could personally email you or someone else that’s trusted the actual copies of the Template and the raw data. It would clear up a lot of confusion. I just don’t trust putting actual info onto the web.
Formatting of current data as the table is only to play with design, actually you will need to format tables returned by Power Query. If you see that new design meets your need, you re-apply it to Power Query tables. To illustrate feasibility I converted one of ranges to table
Power Query requires to work if not with actual when with more or less realistic data. Unfortunately I can't take such project, lot of other work.
- I completely understand! Thank you for all of your help and advice, it is very appreciated!
Stinky111 , you are welcome