if i select a cell then i want row containing that cell selected

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top