VBA to automatize severals actions

Hi there !

I'm currently working on one VBA macro to automatize some actions :


- 1) apply a filter on row 1
- 2) delete dolumn A
- 3) Delete the line with a number 1 in the row A
- 4) Delete the lines with mentions like : cancel, cancelled in the row A
- 5) Count the total of lines and feed another sheet with this number

Thanks for the help !

Best regards,

Pan

Hey,

thanks for the advice !

Here is the file, with the before after sheet ! Also, in the sheet1 i need the J26 filled with the sums of rows after all the operations.

Thanks for helping !

hey.

So, atm the macro isn't working for me, i'll need more help on this i assume.

The macro is in the main sheet but need to work o a different sheet every week or so. Also, there's no mention of the sheet where the macro is working, do you have any idea about that ?

Allright !

It works now, i'm not sure where I was wrong tho... ! I'll analyze it and thanks for the help !

Thanks to you kind stranger !

Ok a little more for me and i'll be fine with this :

Can you add on this macro a fill area where i can type a sheet's name to run the macro on a special sheet ?

Hey !

Well, i'll run this macro on many sheets, but i need to run it like one time.

At the moment, if i run the macro 3/4 times, it removes everything in the sheet. Is this normal ?

To get the macro work only on one sheet of the WB, i would like to implement a way to select one sheet amongst all by either typing his name or any other solution you have in mind.

Thanks a lot !

Yes exactly !

Also, if the Run macro is placed in let's say sheet 1, how can i run the macro into sheet 2 ?