•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Separating Data by Reporting Structure in PQE
Our take
Navigating Power Query can be challenging, especially for beginners. You're looking to create tailored reports for each VP in your company, drawing from employee data that includes multiple Supervisor Level columns. Your goal is to efficiently filter this data by each VP's name and generate individual sheets without the risk of breaking your queries if departmental leadership changes. By developing a dynamic lookup table, you can streamline this process and ensure your reports remain accurate and up-to-date. Let's explore how to achieve this effectively.
Hello! I hope I'm able to describe what I need help with with enough clarity, but I will answer any follow-up questions to the best of my ability. I'm still very much a beginner when it comes to Power Query, so I'm feeling around in the dark here.
I have been asked to create some reports for each of my company's VPs. I have the data I need, I would just ideally like to have a sheet in the workbook for each VP. The employee data I get from my company's HRIS has 6 Supervisor Level columns, so I need to somehow check each of these 6 columns for a given VP's name and pull any returned results into their own sheet. Can I create some kind of lookup table for this so that if a VP for a given department changes i can just update the table and not break the query?
Please help me, kind Excel wizards.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Power Query - Manual Entry and Multiple UsersI have a file with details of open purchase orders. PO numbers are in the rows and there are several columns with various PO details. It is linked via PQ to two other files. It is used by multiple buyers and I'd like to dumb it down as much as possible. I need to be able to do two things that I haven't figured out yet: Each buyer is responsible for updating delivery ETAs on their open purchases. These are updated at different times for a each vendor throughout the week. In the shared file that we previously used, buyers had a sheet for each vendor and we used VLOOKUPS to pull data from these sheets. Obviously, that doesn't work with a PQ chart. Is there a solution to this that I'm not thinking of? I need a column where buyers can manually add notes to each cell. submitted by /u/free-range-human [link] [comments]
- Power query automation with combining two tabsI want to create either a skeleton workbook folder or a template where people can upload their data and it runs all of the conditions on power query that I want. Also, it pulls definitions from a secondary tab and matches them with terms that are from the query and merge them. I basically just want them to be able to paste their data raw and it comes out the way I format it with the steps I’ve already created in query. I have watched every YouTube. Searched. Everything We write a report every month and I am trying to make it a very user-friendly report for them and minimize the extra information They don’t need and also link definitions to be able to understand. Please help. submitted by /u/HeavyBreadfruit3667 [link] [comments]
- Power query for a large datasetMy company uses a horrible format for its daily production sheets, but the data can be pulled through power query. I want to build a reporting tool for looking at any major trends that are currently missed. Ideally looking at part efficiency by machine type and some other descriptive data too like efficiency by shift manger etc. My problem is that even after cutting unnecessary columns and filtering unnecessary rows, it takes forever to load anything. ChatGPT isn’t all that helpful, I’d like some expert advice please! For info, rough number of rows of data is about 50,000 per year. I want to cover at least the last three years. Sheets are all saved into a folder by month, within a folder by year. submitted by /u/CanJesusSwimOnLand [link] [comments]
- How do I Maximize File EfficiencyI work with data sets that I typically look at forecast by year. Currently when I look at 2026 and 2027 it is rougly 1.4M lines of data. I have to put these in two separate data pulls and tables. Then I have six different customers included in this data. so I have to create 6 tabs with six diffrent pivot tables for them to look at. This has created a massive file that lags just to open, save or close so I really have two questions and am open to suggestions. Would it be better to store the data in one worksheet and then link a second worksheet that just has the pivot tables and separated look? If so how would I creat that link? Can you explain to me like I am 5 how I would use power query to combine the 26 and 27 table so that they could be in the same pivot table? Every column in both are identical. submitted by /u/dcal69 [link] [comments]