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

Any advice welcome. Work document instructions followed but result still not up to par. Data missing or duplicated. Copy Paste not captured all data selected.

I'm at my wits end and I can't tell if the problem is me, the person who wrote the instructions, or Excel.

So part of my job is to take an Excel files provide by corporate, transform the data into a table, then split that information up between 4 separate sheets while keeping the table unchanged.

I've been here for 2 months. When I first started the task, I was given a video and written instructions on how to do it. Great. I love that.

Except I follow the instructions and the notes from the video to a T, and there are still a plethora of micro issues, it's like playing whack-a-mole.

Either data is missing that I never deleted, or the file suddenly looses a massive amount of data after being turned into a table, or any other number of errors that have occured in the last 8 submissions.

My direct supervisor says not to be too hard on myself bc it's an intricate process that even she isn't full trained on so it's sort of the blind leading the blind, but that doesn't stop the angry calls from the person down the line who receives the newly formated sheets.

Any advice is welcome.

submitted by /u/Celestial_Ram
[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
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#google sheets
#rows.com
#natural language processing for spreadsheets
#Excel
#data transformation
#table format
#instructions