Forum Discussion
Solved
Help automatically sorting data in excel
Hi, I have data which needs to be sorted by "Security Type" or column E on the Valuation tabs. I have seen a macro online and tried to implement, however it doesn't seem to work for my spreadshee...
calof1 You just need to copy the code you have created from the Module 1 into the code window for the sheet. The code runs off the Worksheet change event so it needs to be in the sheet to operate.
In the Visual Basic Editor, just go to Module 1 and Copy. Then double click on Sheet 4 or whatever sheets you want it to run in and paste it into there. It will work fine.
Excellent! You're welcome calof1