Hello, I am new here because I am interested in learning more about Excel. I also want to ask general questions about the situation I am in to see if it's possible to do what I am trying to accomplish.
Everyday I run a set of reports to send out to my team that include about 8 different reports. All of them have filters to do so by date and other information, they also have formulas. Someone sent my manager a macro for most of the reports he runs, and now that I have seen it I want to teach myself how to do it the way he did. His macro for starters is a button that he created, and all you have to do is hit it and it runs the macro's. Another thing is, he created an actual xlsm file with his macro and it includes more than one report and once you hit the button it runs them all at the same time. Can anyone point me in the direction for me to teach myself how to do this?
Another thing is when I filter the dates during the recording of the macro, once I run it the filter selects a different parameter of dates. I know that's alot, but thanks in advance for the help.
Everyday I run a set of reports to send out to my team that include about 8 different reports. All of them have filters to do so by date and other information, they also have formulas. Someone sent my manager a macro for most of the reports he runs, and now that I have seen it I want to teach myself how to do it the way he did. His macro for starters is a button that he created, and all you have to do is hit it and it runs the macro's. Another thing is, he created an actual xlsm file with his macro and it includes more than one report and once you hit the button it runs them all at the same time. Can anyone point me in the direction for me to teach myself how to do this?
Another thing is when I filter the dates during the recording of the macro, once I run it the filter selects a different parameter of dates. I know that's alot, but thanks in advance for the help.