I have set up a simple budget and spending spreadsheet with separate sheets for each month. The sheets are basically the same, columns are the same, but the number of rows may vary. I need to set up a macro that will sort an individual sheet on 3 columns and be able to use it on any other sheet. Every time a build a macro to do it, it only works on the sheet I was on when I built it. How do I build 1 macro that will work on any individual sheet in the book?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!