i want to copy all rows that contain a cell with certain value.
M Max Feb 22, 2007 #2 Do a Data > Filter > Autofilter on the key col, filter out that certain value, then copy the filtered rows, and paste special as values/formats elsewhere as required
Do a Data > Filter > Autofilter on the key col, filter out that certain value, then copy the filtered rows, and paste special as values/formats elsewhere as required
