2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Need Excel workflow advice for multi-region data cleanup and tracking progress

Hi excel pros,

I work for a company with about 20k employees, and I’ve got a spreadsheet of roughly 2,000 people who are missing data for two required info columns. These employees are spread out across different regions, and then further down to individual locations/teams.

What I need to do is send each region only their portion of the data, have them push it out to their locations to fix, and then somehow track what’s been completed and pull everything back together into one clean file.

In the past, I’ve been filtering data, saving separate files, emailing them out, then trying to keep track of who’s done what and combining everything back together. I’m worried I’m going to run into version control issues or miss updates. It’s also very cumbersome and it has ended up just being a big stressful mess in the past.

I feel like there has to be a better way to handle this, but I’m not sure if I’m overcomplicating it or missing something obvious in Excel. I’m very much a basic user and not super familiar with more advanced features, but I’m willing to learn.

Has anyone set up a process like this before? Appreciate any advice or ideas. Even just “here’s how I’d approach it” would be super helpful.

submitted by /u/Magnolia05
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#big data performance
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#Excel alternatives
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software