
Last seen: Aug 19, 2025
Well, you could start by sharing some example data. Replace any confidential information, like real names, with made-up ones. You can upload a file wi...
Please elaborate and clarify what exactly you would want to extract from the example texts in your post.
Makes sense Anders! I totally misread the OP's intentions. Tack så mycket!!
I'm afraid PQ can't create a schedule like you attached to post nr 9. It's a formatted report with boarders, colors, a picture, checkboxes, data valid...
You may want to have a look first at Mynda's blog post on how to create a P&L with a regular pivot table. It's not all that complicated. Excel ...
I didn't notice your post number 6 until now. Sorry for being ignorant, but I don't know what you mean. what would you want to extract and how shou...
I didn't notice your post until today. Looked at your file but have difficulties understanding what you exactly want. You have successfully applied co...
Thanks for the file. But now please explain what you want to do with it/them. Say, you have 10 of these sheets what data would have to be extracted...
Please upload a file (or files) that demonstrate the actual structure (or lack thereof) of the data. Without that, it's difficult to help.
I'm really sorry but don't understand what I'm looking at nor what you need. It's difficult based on a picture alone.
In PQ you can navigate to the Folder containing your files. Press 'transform' and filter for the file extension you want to connect to. In your case "...
As I understand, you renamed column headers in a table that sources a pivot table. Correct? Let's say one pivot table (pt) uses the Manager column ...
From what I understand, you need to un-share the Pivot Cache for both pivot tables. It is explained in this blog post by Mynda: Excel Pivot Cache •...
@Hans To avoid OFFSET, in modern Excel you use the # sign to refer to an entire spilled array. So, in your example you can refer the named range It...
Consider it closed, but you should have informed us about cross-posting in your first post.