Macro will not carry forward to next spreadsheet…

[BudParker]

I have a workbook to manage people arriving and departing work location. Name, etc. in rows. Every day I sort the data by 3 criteria. Creating the macro is simple and it works fine; except when I copy the spreadsheet tab and create the next day’s sheet, it won’t function. Also, other users can’t use it.

Are there different types of macros? How do I insure it will be useable by my fellow office workers when they log in? By the way, thanks in advance...

[JBeaucaire]

Yes, there are different kinds of macros. Some are designed to work on one sheet, you may have accidentally created one of those. Others work on the "active sheet".

The best macros can work on any sheet and dynamically figure out where they are and where the data needs to go (if to other sheets).

Some macros require you to trigger them, others will trigger themselves by some "event" that occurs.

If you post your workbook and/or your code, we can discuss the issues you're having directly.