•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Tips to get an entire row if a specific cell matches a range of criteria.
Our take
Are you tired of manually copying rows in Excel every time a specific cell meets your criteria? If you're using two workbooks—one macro-enabled and another as your test subject—you can streamline this process significantly. By leveraging a macro, you can automate the task of copying entire rows based on a condition in the B column. Instead of repetitive manual effort, discover how to set up an efficient solution that only requires a single command. Let’s explore the steps to simplify your workflow and enhance productivity.
I am using 2 excel. 1 macro enabled, the other is the test subject.
I need to either copy the entire row from test subject to a test sheet on the macro workbook. The caviat is that in the test subject. I only need to copy the row if the value in B column matches a given criteria
The best approach I can do is via macro. However, I don't want to press the same macro command 100 times.
How do I approach the issue I got?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience