Ok Everyone,

You have helped this novice before, and I have been searching through the forum for some time now to find how to do this. Basically as an accountant for a school I run a TON of queries that have a variety of information. There are mutiple fund sources involved and I need to move all but one source to the bottom (insert lines to seperate the top source from the rest). I am in need of some code that will find the other sources, cut them, and paste them at the bottom. The tricky part is that every query has a variety of rows so I never know what the last row is. Below is some code that I obtained from a previous accountant and from the record macro function, but it only moves the "STATE" source to the bottom and there are still a handful of sources that remain and need to be moved. Any advice would be appreciated. Also if any changes to the current code can be simplified please let me know. 

Please Login or Register  to view this content.