Sorting data from a column to corresponding area

Hi,

I'm trying to have a script assigned to button where when the button is pressed then all the data that is in a column will be sorted out so that the data is moved to the corresponding area within the same sheet.

More detail ...

Column E contains codes and text, the text is for a department and the codes belong to that department. Columns B,C,E and F and the areas where the codes that belong to the department are then moved to.

This is a link to the file I'm working with.

https://www.dropbox.com/s/06k066b55p...3.2%20BETA.xls

The code attached to the SORT button has come from kevatarvind over at ...

http://www.mrexcel.com/forum/excel-q...cell-data.html

Any help would be most appreciated.

Can I have a Bump ...

Hi Alex.ransome,
try it

Please Login or Register  to view this content.