1. Open the file that has name, time and date
2. auto filter zero in a specific column "AL" and remove all the rows that has zero
3. disable auto-filter than save and close the file
4. copy the same file to another folder and paste it
5. delete the old file that is already there which is 30-45 mins old
I have to do this task every half an hour to 15 mins with the other tasks and i want to automate this like others i'm quite new to VBA macro and this forum has helped me a lot to get done several other projects
Sorry for being needy for my first post here but i can't crack this i have few points covered but i keep getting stuck in one or the other errors. Please help!
2. auto filter zero in a specific column "AL" and remove all the rows that has zero
3. disable auto-filter than save and close the file
4. copy the same file to another folder and paste it
5. delete the old file that is already there which is 30-45 mins old
I have to do this task every half an hour to 15 mins with the other tasks and i want to automate this like others i'm quite new to VBA macro and this forum has helped me a lot to get done several other projects
Sorry for being needy for my first post here but i can't crack this i have few points covered but i keep getting stuck in one or the other errors. Please help!
