need to change a macro that works only for a specific worksheet to work for others, also

I need to change a macro that works only for a specific worksheet to work for each among other worksheets individually [not sequentially], e.g.. to run in a worksheet with a different name like a modified copy of the original worksheet.
I'm working in Excel 2011. The following code runs in a worksheet called NOW. What's the easiest way to get it to run in all worksheets? I've looked around & tried various things but nothing has worked yet. I'm a super-newbie. Note: the comments are not specifically accurate because I edited the copied code to make it work for me but not the comments in case I needed to backtrack. [I got the original code here & it was a lifesaver]. Thanks!!! Shawn

Please Login or Register  to view this content.