•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
First Time Trying to Code in Excel
Our take
If you're venturing into coding in Excel for the first time, you're not alone. A common task is creating a function that automates the search for specific values, such as case IDs, across multiple sheets. In your case, you want to identify these values and delete the corresponding rows, while preserving a master data sheet. This is absolutely achievable with Excel's capabilities. Let’s explore how you can implement this function effectively to streamline your data management process.
Hello,
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Help locating specific data from rangeHello all, I was wondering if someone could assisst me. Im still learning excel and having some success, but currently im struggling with a problem. I have a bunch of data across multiple cells. Some columns would have time stamps, location, error codes, vehicle numbers etc. Lets say i have a bunch of data for all vehicles and errors. How would i go about automatically filtering through the data looking for, example, error code 515. Ideally have an entire sheet that shows all data but just for a specific error code. Or a name. I appreciate any help on the matter. Even if you point me in the direction of useful information, videos etc. Id be very grateful. Thank you submitted by /u/liveactiongeek [link] [comments]
- Transfer Data from One Workbook to Another (SPILL Issue)Hey! I’m working on an Excel setup where the workbook on the left is my source and the one on the right is my destination. My goal is to automatically transfer the “Given IDs” from the source to the destination based on their assigned codes. I fixed the one‑to‑many lookup issue, but now I have another problem — when I type an existing code again in the destination (highlighted in green), it shows #REF! instead of its IDs. Is there any way to fix this without losing the automatic transfer I already have? + A user suggested to the COUNTIF into a MOD. I'm not sure how to operate this so I hope anyone could teach me. + "FILTER('[book 2.xlsx]Sheet2'!B:B,ISNUMBER(XMATCH('[book 2.xlsx]Sheet2'!A:A,B:B)))" = this also helps but I also encounter the aforementioned problem (in my real workbooks, there will be times when I need to enter the same codes directly in the destination, and I don’t want to keep going back to the source workbook to re‑enter them all over again.) Thank you so much in advance! https://preview.redd.it/cb9jv0h57ryg1.png?width=1314&format=png&auto=webp&s=b26b1b2886d53f8fe94b76735e4de21ea9a3b866 submitted by /u/jeankrstein [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#generative AI for data analysis#rows.com#real-time data collaboration#no-code spreadsheet solutions#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#google sheets#row zero#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#real-time collaboration#Excel