•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Extract Rows of Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria.
Our take
Are you feeling overwhelmed managing schedules across multiple sheets for your manufacturing jobs? You’re not alone. The challenge of extracting and filtering data from three separate sheets into a fourth for effective prioritization can be daunting. Imagine a streamlined solution where your data populates automatically, allowing you to focus on what truly matters—meeting deadlines and optimizing workflows. In this guide, we'll explore how to efficiently combine and filter your job data, ensuring you have a clear view of all tasks assigned to a single employee.
I'm working on a scheduling document where I have manufacture jobs being undertaken across three sites, each of which have their own sheet to track jobs with information including the due date, client name, employee, and some job relevant codes as well as some tick boxes (nine columns per table).
I am attempting to create a 4th sheet to track jobs across all 3 sites undertaken by a single employee to be used a tool for good prioritising. I would like to be able to take the full rows of information from the existing three sheets and have them automatically populate the 4th, and be able to sort the 4th sheet by a due date column.
I have played with =FILTER functions and tables converted to ranges, but haven't found a solution where the the table can be filtered and self-populatin from the 3 sheets at the same time. It's either one or another.
Any help would be appreciated. Thank you.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Extract Data Across 3 separate sheets, and combine in a 4th sheet, filtered by criteria.I'm working on a scheduling document where I have manufacture jobs being undertaken across three sites, each of which have their own sheet to track jobs with information including the due date, client name, employee, and some job relevant codes as well as some tick boxes (nine columns per table). I am attempting to create a 3 more sheets to track jobs across all 3 sites undertaken by a single employee to be used a tool for good prioritising. I would like to be able to take the full rows of information from the existing three sheets and have them automatically populate the 4th, and be able to sort the 4th sheet by a due date column. I have played with =FILTER functions and tables converted to ranges, but haven't found a solution where the the table can be filtered and self-populatin from the 3 sheets at the same time. It's either one or another, and following a previous post havbe tried using suggested formula such as =FILTER, and =LET. I ahave attached screenshots below of what the document is somewhat like at the moment. In Them there are two site 3 sheets. The alternative is in a f Layout similar to the one currently used on that site. This new workbook is to replace an old workbook with no conditional formatting and lacking necessarry info, wher hoghlighting and data input was all completely manual. Sheet 1, uniquely column E is' A or B' as only two job types ar done on this site and all are delivered at appointment. Sheet 2, Column E is now 'Delivery Method' Sheet 3, Column E had been kept for conisitancy across the sheets despite all jobs being delivered at appointment. Alternative Sheet 3, This is the layout similar to the current one used in teh business with a seperate diary for each technician for just this site, with a working week on the left most column. Sheet 4, I would like all the jobs for one technician across the three previous sheets to automatically populate theis sheet using formulae. Any help would be appreciated. Thank you. submitted by /u/Omission5000 [link] [comments]
- How to filter data on different sheets simultaneously?I'm looking for a solution to the following problem i'm facing: I have an XLS file with a bunch of sheets containing data inside. Each sheet contains a table with data. The data in each table is used to calculate values in a seperate overview sheet within the same file. Now, here is my question. Each of the tables in the sheets contains a column with an identifier and i would like to use this column to filter the data in the tables in all sheets simultaneuosly and have the data in the overview sheet re-calculated based on the applied filter. Example: Each table in each data sheet contains rows that have the identifier "A", but there are also rows of data with different identifiers. The data in the overview sheet uses all rows of data as a calculation basis. I want to apply a filter for identifier "A" through every table and have the overview sheet show calculated values for the filitered data only. I tried searching for solutions, but haven't found anything feasible so far. Hope, you understood my problem and maybe someone knows an elegant solution. If needed, i can provide a sample set of data in the structure i've described. Thanks a lot in advance! submitted by /u/henrikgreger [link] [comments]
- Help filtering data from new sheetsHi all, I want to keep a database of the different types of tasks I do at work. I've stuck with this and would greatly appreciate a solution! I see clients daily and keep a record of who I see in a workbook. There is a sheet for every day with that day's client list, with columns for name, contact details, and task. The task column is a drop down list that I've made with Data Validation. Options are "water leak," "low water pressure," "blockage" etc. It's important that I can use a template sheet and copy it every day, then populate the new sheet with that day's client list. I now want to make a database by bringing the client details into a new sheet and filtering by task. I want to keep record of this going forward, but doesn't have to be retrospective. I've been able to do this for one individual day (which is one sheet) by using FILTER=, but this only works for one sheet at a time. How can I set this up so that when I make a new sheet from the template every day, the task category is recorded in a seperate 'Database' sheet with the client information? It would ideally look like a list of, for example, rows of all the water leaks I've gone to, with the client information for each one. Thank you so much for any help 🙏 submitted by /u/PresentationStock216 [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]