hi everyone,
i was wondering if it's possible to copy/paste a row in excel if a cell contained certain criteria. for example, if the cell has the word "value fund" in it, then take the entire row that the cell is in and paste it into a new worksheet? also, i need to do this for about 6 different names in different cells (all cells are in the same column) if possible.
Thanks!
i was wondering if it's possible to copy/paste a row in excel if a cell contained certain criteria. for example, if the cell has the word "value fund" in it, then take the entire row that the cell is in and paste it into a new worksheet? also, i need to do this for about 6 different names in different cells (all cells are in the same column) if possible.
Thanks!