•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to build an Excel ‘database search’ that opens another file to the right row — possible?”
Our take
Are you looking to enhance your colleagues' data management experience with Excel? You can create a dynamic search tool that allows users to find specific entries by name or ID and directly access the corresponding row in another file. This project, while ambitious, is certainly achievable with a mix of Excel functions and VBA. By incorporating buttons that open the relevant files and highlight the exact row, you can streamline workflows and empower your team.
So I have this mini project that I wanted to do. I genuinely wanted to help my co-workers with their databases (or data banking as they say). The goal is to create an excel file wherein when they could search for a person using either an ID or name and they could click something like a link or a button and then it'll open another excel file/s and get to the exact row based on the ID and/or name. The files that'll be opened could vary so I was thinking of buttons that opens the file and highlight or locates the exact row based on the ID. I'm not sure if this could be done. I wanted to give this a try but I just don't know the term to search for. Is this doable? Any ideas how or if there are other suggestions? I'm not an expert at Excel but maybe above average. I know a little bit of VBA but I'm willing to learn. Hope someone could help to search for the right term.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Looking for project tracking ideasHi, As the title suggests I’m trying to create an Excel sheet that tracks the progress of various projects. Essentially, I was given a messy excel document to look after. I don’t have particularly advanced skills and nor do I want to spend too much time on this. So… One sheet lists projects as rows and they all have a reference code. There is a column designated for “action updates” where people overwrite progress each month. Other columns exist for project status, dates etc. My idea was to create another sheet which also lists the projects but acts as an action/change history log. I attempted to have a drop down through grouped cells that would act as a historic list of all changes and action updates around each project. The row with the corresponding project number would act as a “live view”, so using an X look up to display this data on the original sheet. Is there a better way to create something like this? There must be loads of ways to do something like this, but I just can’t think which way to do it!! Thank you for any help!!! submitted by /u/Formal_Disk_3760 [link] [comments]
- Search Bar thats acts like a SlicerHello! I am working on a data entry that requires a search bar for specific values that is also editable. I have been looking for solutions but all I have are the following: Table slicer (which is good, but when you have 100+ accounts and need to search for a specific account, it’s not viable) =Filter(table) function, which is also nice but it won’t let me edit the data from the results. Is there an actual way to create a search bar applied to the main table, and when I search through it, I can edit the data without ruining the table? Basically a search bar that acts like a slicer. I’m fairly new to developer functions in excel, I’d really appreciate it. Thank you! submitted by /u/PsychologicalAct4026 [link] [comments]
- What would it take to have a cell that does a Vlookup based on the cell that's currently clicked on?Apparently the sheet already crashes here and there so I suppose the more elegant the solution the better. We have these big meetings where we will run through hundreds of projects and their costs. It's my job to monitor how a different variable is getting managed if a project gets moved in or out. Everyone else is really only concerned with the money, Currently my steps would be: Look at the sheet the presenter is showing, open a sheet on my laptop, manually type the project number in a search, see the variable assignment, then I check another sheet to see how that variable is performing. Ideal setup would be: As the presenter clicks on a project, in the corner of his screen it looks up the project and shows the variable. Now I can just have my variable performance sheet up on my laptop and respond quickly since the info is already looked up and on his screen. I used to be pretty good with VBA, though haven't touched in 5-10 years - open to those types of solutions as well. submitted by /u/TimelyExtent2402 [link] [comments]
- First Time Trying to Code in ExcelHello, I am trying to create code in Excel that will perform an automatic function; That function is to search the workbook for any other instance of a value (case ID) from the other sheets and delete that row once it is placed within a new sheet (excluding a data sheet that houses all the case IDs). Is it possible to do this? submitted by /u/Techbeef [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#generative AI for data analysis#natural language processing for spreadsheets#row zero#cloud-based spreadsheet applications#rows.com#big data management in spreadsheets#conversational data analysis#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel#database search