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

Data Entry and Cleanup of Current File

I have a history file that I have kept for about 8 years. I have now lost about 8 months of data and if I am going to re-add all of it, I would like to streamline my entry.

https://preview.redd.it/ks4dit5faupg1.png?width=1768&format=png&auto=webp&s=e1b81013d9be141ea75618dfdb80e4ac868a072b

My current layout is very utilitarian.

Equipment is separated by sheets, then broken down from there.
For the example in the picture, I have the main equipment for the sheet, the "child" on the left by line, the date the piece was repaired, and the comment was the text that was entered in the turn report.

I have built a userform to help input information, but it is clunky at best.

https://preview.redd.it/fbe9hyuhbupg1.png?width=1152&format=png&auto=webp&s=508b9325221c08f96485f02d086f8ad601e7babb

It is still very manual for me to enter information. The way the I receive the data is this:

https://preview.redd.it/uhh228w3cupg1.png?width=779&format=png&auto=webp&s=504fabe9576c5a7084a6d1802ccc1355faa058dd

Long post short, any suggestions? I have thought about fiverr, etsy. I dont mind spending some of my own money to make my job easier. The company I work for does not have an interest in saving this data. Each time it has been brought up, they tell me to use Tabware CMMS, which is built like windows 95 and the people that built it dont call it by the name that we use in the field.

submitted by /u/Fabulous-Contest-553
[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
#natural language processing for spreadsheets
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#google sheets
#real-time collaboration
#Excel alternatives
#data entry
#data cleanup
#history file
Data Entry and Cleanup of Current File