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

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?

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#row zero
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#Excel
#macro
#criteria
#test subject
#test sheet
#copy
#row
#column B
#automation
#data transfer
#workbook
#vba
#value match
#caviat
#command
#execution