•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Comparing sheets for changes
Our take
Navigating changes in engineering reports can be challenging, especially with daily updates and fluctuating rows. If you're new to Excel, leveraging tools like Power Query can streamline this process, but it requires careful setup to avoid flagging entire rows for minor cell changes. Instead of relying solely on IF functions or conditional formatting, consider refining your Power Query setup to focus on specific changes. By honing in on the exact alterations, you can efficiently log updates for your team without unnecessary clutter in your reports.
I'm relatively new to Excel, and I've been scratching my head at a problem. I get a daily list of changes to engineering reports and I need to compare them with the previous days to log changes for my team. I tried using an IF function and conditional formatting, but the report frequently has rows added or dropped as engineering reports are closed and opened, so it was flagging over half the sheet as new changes.
I've had some success with Power Query but if a single cell changes, it flags the entire row for me. I only learned Power Query in the past week so it's entirely likely my issue is in merging the charts incorrectly. Any advice would be much appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Power Queries as inputs changeI have a main spreadsheet that is fed by some instrument logs among other things. These inputs change from time to time due to instrument software updates. I can update the power Queries but then it breaks the old files. How do people handle this? submitted by /u/Javaslinger [link] [comments]
- How to consolidate multiple sheets into one YTD summary report?I have 52 sheets in my excel workbook. It is named in a non-traditional sequence: "Jan Wk1, Jan Wk2, Jan Wk3,...... Dec Wk 4, Dec Wk5", because it's easy for me to print a weekly report with a total for each category. https://preview.redd.it/rq7qb3x8ddyg1.png?width=814&format=png&auto=webp&s=9d101ae17b185451e5140ef1c17f86221cd83aa6 Log 2026 is what my spreadsheet looks like. I only included three weeks as an example. Cell H34 in the highlighted area, on the Jan Wk2 sheet, contains a VBT to retrieve data from the previous sheet. Each day, I also need the total from the previous day in C36:G37. I like my current setup because I can easily convert it into a weekly PDF report without any modification. However, I'm not sure how to create a YTD summary report from 52 sheets. A template of the YTD report is included in Log2026. I tried to use 3D formulas, but I have to manually change sheet names and adjust cell references when crossing columns and rows. not very pragmatic and easily make mistakes. Log 2026: https://drive.google.com/file/d/1IEavZiJiDOv4GS-8c6n8dJqHUnRfT-ft/view?usp=drive_link ***************************** Some people suggest combining a year's worth of data into a single spreadsheet, rather than 52 weekly sheets, and then using Power Query to populate the report, but I am having difficulty generating the weekly report using the preferred template. Preferred Pdf report example: https://drive.google.com/file/d/1uQW7z_XZJ_Nn5sAzcaTkXDObAu8XTi0e/view?usp=drive_link Screenshot of combined data Completed data: https://docs.google.com/spreadsheets/d/1xIJkqTOwjucN2QMT0pK6A6wmSp8U4U8A/edit?usp=drive_link&ouid=102145557861966136866&rtpof=true&sd=true highlights: data collected daily, so every day is different. data for the drivers on the bottom of the spreadsheet changes based on their starting date. So my goal is to create a weekly and yearly report with preferred template (boss's request). Any suggestion is appreciated. submitted by /u/Ok_Solid_9312 [link] [comments]
- Consolidate data from different worksheets with final information coming from a combination of the worksheetsHoping for some help on a problem I can't wrap my head around. I need to consolidate some information from 12 different tabs (one data pull per month) into one worksheet with some of the data needing to be overridden and some needing to stay. With the most recent pull of the data not necessarily being the information I want showing, I'm not sure how to proceed. I'm trying to find a way to create this and pass it along to someone else to just load data and it automatically puts out the result I'm looking for. For instance, I pull information from my system in January for the entire year (broken into monthly buckets) and all of that is perfect. My second data pull of the year in February isn't so clean. I need to see the numbers from January on any of the January data (because it zeros out in February in my system) but everything related to February through December needs to be from the most recent data pull. Third pull of the year in March, I need to see the numbers from January and February for the January and February data and then need the new info for March through December. Basically, by the time December rolls around, I need data from all 12 sheets. Hopefully this makes sense. Any thoughts on how I can accomplish this in Excel? submitted by /u/megd726 [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#row zero#interactive charts#google sheets#Excel#engineering reports#Power Query#compare#changes#IF function#conditional formatting#log changes#report#cells