•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pulling data from one sheet based on a column
Our take
If you're looking to organize your tasks by month in Excel, pulling data from your Master List is a great approach. You can create individual sheets for each month that reference the IDs in Column A, allowing you to easily see which tasks are due. To achieve this, using a combination of Excel functions like VLOOKUP or FILTER can streamline the process and prevent duplicate entries highlighted in your Master List.
Apologies I’m not that experienced with Excel.
I have a sheet with dates that a task needs to be completed (sorry for the photo of a screen but work IT won’t let me screenshot).
I have a Master List sheet of all dates due (column D adds 48 weeks to Column C and Column E extracts the month from D).
I want a sheet for each month and for each month’s sheet to pull the IDs from Column A so we can just look and see which tasks are due in e.g. January. And so that all are visible in the Master List so we don’t end up with duplicate IDs (column A has highlight rules for duplicates).
I tried google and think it might need VLOOKUP but couldn’t seem to get it to work.
Thanks.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Want to copy data from master sheet to seperate sheetHi, I am an excel newbie and I would have added a screenshot but it is all in Dutch. I am in charge of the guestlist for a big company multiple day event in October. Right now I have everyone in one sheet with their names and contact information and also a column (M) which is the day they will be invited for the event. it's either on the 30th of september, 1st of October or the 2nd of October. I do not know if it is possible but I would like to have the whole row copies to a different sheet when I fill in the date they would be invited on. So if person A gets an invite for 30/09, I would like the full row of their information to be copies to my different sheet that is specifically for all the guests of 30/09. This way I have my own sheet with everyone that is invited from 30/09 until 02/10, and then different sheets per day. Is this possible to do this with a formula or something more automatic instead of copy pasting the lines myself? Thank you submitted by /u/Necessary_Fennel581 [link] [comments]
- Pulling data out of multiple tables across sheets to a master table?I am seeking to make a workbook that tracks to do lists across multiple different projects at our firm. We have about 50 projects going, so I made a pivot table and created a sheet for each project. Next, I want each sheet to have a list of tasks and deadlines, my thinking is that I need to make a table on each sheet, and then find a way to pull each respective table’s task/deadlines to the master sheet. Each project has different number of entries, or none at all is there a good way to create a table on each sheet without having to do it individually on each sheet? which function do I use to pull the data from each table into the master table? thank you for your explanations & education in excel submitted by /u/randominternetguy3 [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]
- Using Data from Two Sheets to find classesI work in a corporate job and somehow became the person on my team that knows excel best. I’m okay with excel. Not an expert. But I need help. I have a spreadsheet that lists available training classes and how many seats the class has and how many are still available. I also have a sheet of learner requests for classes. I would love to combine the data and be able to query or pivot to show a list of students that could be enrolled into available classes. What’s the best method of going about that? Thanks. If I need to go elsewhere to ask questions like this please direct me. Thanks. submitted by /u/Coffee4words [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#financial modeling with spreadsheets#Excel compatibility#Excel alternatives#rows.com#google sheets#big data management in spreadsheets#conversational data analysis#cloud-based spreadsheet applications#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel#sheet