I have a sheet with combined values for different units and I manually sort into the different units manually by copying and pasting into another sheet. I will very much like to have a program that will sort and transfer these values automatically into the second sheet in the different units.
Could you please upload a sample of your work book showing its actual set out and exactly what you are trying to do. You can upload a sample by using a free file sharing site such as DropBox, ge.tt or SpeedyShare and then post back here with the link to your sample file. Please be careful with any sensitive data.