I'm looking for a way to copy a range of cells, but to only copy the cells that contain a value 1 i would like to do the following Find all cells containing a certain keyword in a column in an excel spreadsheet Select and copy the entire row which includes the cells which have the keyword mentioned in point 1) paste these new rows into a separate spreadsheet. I want to copy row data that matches specific column data The column data i want to match on is composed of sales contact names
The sales contact names rarely change The column header never changes, it's ak I'm building a macro to copy data rows matching only those contact names i've listed in column ak. It looks for cells which match our criteria which we have specified to be >= (greater than or equal to) 10 So, if these values are found then the code moves to the next stage of code In this case, the next stage is to show the value in the matching row in column a in column e
