Forum Discussion

calof1's avatar
calof1
Iron Contributor
Jan 02, 2020
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...
BI & Data Analysis
Charting
developer
excel
Excel on Mac
Formulas and Functions
Macros and VBA
power bi
  • Alan_Murray's avatar
    Alan_Murray
    Jan 02, 2020

    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.

Alan_Murray's avatar
Alan_Murray
MVP
Jan 02, 2020

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.

  • calof1's avatar
    calof1
    Iron Contributor
    Jan 02, 2020

    Hi Alan_Murray 

     

    Thanks for your help, it now works perfectly.

     

    Thanks again, very much appreciated.

Resources