1 min readfrom 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?

submitted by /u/Techbeef
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Related Articles

Tagged with