Hello all. I was wondering if anyone would be kind enough to direct me to the Macro coding I need to simplify my quarterly reporting.
I have a large excel worksheet that is updated twice a month and lists organizations, the location of these organizations, and amounts given to each. To simplify my reporting I want to create a macro that would copy the organizations funded for a year I specify into a newly created worksheet with the amounts awarded them and separated by their locations, all within the same file. So in essence, the macro would create a blank worksheet that lists organizations, Sorted by location for a year I specify. This would allow me to alter only one worksheet and gaurantee the integrity of my report.
Any help would be appreciated. Thanks all!
I have a large excel worksheet that is updated twice a month and lists organizations, the location of these organizations, and amounts given to each. To simplify my reporting I want to create a macro that would copy the organizations funded for a year I specify into a newly created worksheet with the amounts awarded them and separated by their locations, all within the same file. So in essence, the macro would create a blank worksheet that lists organizations, Sorted by location for a year I specify. This would allow me to alter only one worksheet and gaurantee the integrity of my report.
Any help would be appreciated. Thanks all!