Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

excel Macro Help

  Asked By: Clifton    Date: Nov 24    Category: MS Office    Views: 1088
  

I recorded a macro in excell that contains 15 col and 500 rows, in col
10 I only want to display a certain value (i.e W2) and delete or hide
the rest of the rows. Any help or the actual macro to do this will be
appreciated.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Marina Smith     Answered On: Nov 24

Easiest way is to filter the data using Autofilter to hide all the rows except
those containing the value in column 10 (J) you want to see. You can do this
without VBA, or you can create a macro  by recording yourself applying the
Autofilter and selecting the desired value.

 
Didn't find what you were looking for? Find more on excel Macro Help Or get search suggestion and latest updates.




Tagged: