sorting macro

Hello---- I am pretty new with VBA/macros, and I am having a very difficult time creating a sort macro. We have an SQL based database management application and when we run reports it spits out many unused and/or unused columns. I have been creating .xlsm templates to cut down some of the work...

Hi, In sheet 1, I have names starting on B2 and all the way down. Starting on I2, I have values for those names. I am wondering if it is possible to sort these numbers onto sheet 2, largest number on top and decreasing. the values would start on B2 of sheet 2, and the corresponding name, which...

Hi, I have a file with c. 50 pivot tables feeding off a selection of datasheets in the file (each pivot table is in its own sheet). All the pivot tables are currently sorted on one data field (same one for all pivot tables). I now need to re-sort all the pivot tables on another field (again it...

I have been searching the depths of the internet to try and find the answer to this problem and just cannot find what i need. I am creating an Index to house a list of projects and i want the user to be able to filter the projects (which are all listed in the rows below the selection...