Hello,
I need help to create a Excel macro.
Basicly what I have is a sheet full with information about different departments and what I want to do is delete every row EXCEPT the rows that contain some specified values (wich i would like to enter on running the script).
Lets say in the column that names the department (in my sheet named "Avd"), i would want the script to look for any cell that does not contain, for example, the numbers 1, 3, 5, 6 or 21... and so on (i have about 36 different numbers).
Is there any good way to do this?
Thanks very much for your time.
/M
Configuration: Windows XP Internet Explorer 6.0
I spent a lot of time trying to figure this out and finally got the correct Macro. All you have to do is highlight the information in the column and then run the following Macro. There will be a box that will prompt you what vaule you want to keep. This is good for up to 30,000 rows.
|
Hi,
|