•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Making a fillable form with dropdowns and sections that can be added and moved easily
Our take
Creating a fillable form with dropdowns and easily movable sections can significantly enhance your spreadsheet for logging ladder inspection statuses. With your experience in Excel, you can implement features that allow for dynamic reordering of ladder details and the seamless addition of new sections for incoming ladders. This approach not only streamlines data management but also ensures accessibility for your clients who rely on Excel. If you're open to alternatives within the Office suite, consider exploring tools like Microsoft Forms or SharePoint for enhanced functionality.
**SEE ATTACHED IMAGE**
I am attempting to improve this spreadsheet. I have a decent amount of experience with Excel but I am unfamiliar with the terminology require to describe the exact functions I am attempting to implement.
The function of the sheet is to log various statuses and information pertaining to ladders and their inspection status.
Each workbook has a header section and a footer section to diffentiate between clients.
The sections that detail the individual ladders need to be moveable / re-order more easily, and also be able to insert a blank ladder section for any new ladders that come into service.
The reason excel was selected is for access reasons. All of our clients use excel, but if there is an objectively better tool for the job that is part of the Office suite that people can use via the web or with their Office licence then I will consider that.
Thank you to everyone who is able to provide some insight into this.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- using MS forms with excelHello! I have a massive spreadsheet that I need to use for lots of reporting. I've tried to pare it down as much as possible for those who have to do the actual data entry, but they are still very overwhelmed by it (they really don't understand how to even use filters to narrow down the scope) and so the data coming out is not reliable. I've never used MS forms in conjunction with excel, but I'm thinking that if I create a form for them just to enter the basics, I would at least have correct data for my analysis piece. The only thing I'm concerned about is that there are updates to entries that need to be made (ie- someone earns an additional level of certification or they drop out of the program). Can this be accomplished with forms? Or am I barking up the wrong tree. I was hoping to get some advice before I start really teaching myself how to use MS forms (any suggestions for good tutorials would be great too). Thank you in advance! submitted by /u/bluellama314 [link] [comments]
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- I built a tool that lets you skip Excel formulas (would love your feedbacks)Hey everyone, If you work with Excel a lot, you probably spend way too much time figuring out formulas and structuring data before you can actually get insights. I’ve been building a web app called Neural Sheet to simplify that workflow. Instead of writing formulas manually, you can just upload your Excel file, describe what you want in plain language, and it generates the result for you. You can then download everything back as a normal Excel file with full control. It’s still early, but most core features are already there, and I’d really value honest feedback from people who actually use spreadsheets daily. You get 30 free edits to try it out. If you hit the limit and want more, just DM me and I’ll top you up. Would love to hear what works, what doesn’t, and what feels missing. submitted by /u/NeuralSheet [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#rows.com#modern spreadsheet innovations#self-service analytics tools#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#self-service analytics#spreadsheet API integration