How to use macros that can work on different Worksheets

I'm pretty novice at programming Macros and coding VB so this is must be very basic question but I can't figuring it out by myself. I have recorded a Macro that moves and arranges some cells around my worksheet .it works wonderful until I tried to apply this Macro on another worksheet and then it stopped working right were the file name of the previous document was. My question is how to replace the filename in the macro with a veritable or current worksheet statement so it will work always with every file that I want.

Example:

Please Login or Register  to view this content.

Remember CODE /CODE tagswhen posting code on the forum. Thanks. Fixed abive.

Maybe like so:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Try this code? I just changed Worksheets("Download (6)") to ActiveSheet.

Assuming that column is column D, this is how I would do that, we delete all the found rows all at once at the end.

Please Login or Register  to view this content.

Your welcome SteveBA. I'm glad that worked for you.

Try JBeaucaire's suggested code above and let us know if it works also (and try to mark the thread as solved if this concludes the issue).