View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default if i select a cell then i want row containing that cell selected

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Maaz" wrote:
i want to copy all rows that contain a cell with certain value.