•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
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]
Want to read more?
Check out the full article on the original site
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