Autosort on different worksheet cell change

  • Hello,

    New to the forums but I have read many of them dealing with my topic. Sadly i have been struggling with this for hours and I can't seem to get it to work. Any help would be greatly appreciated! Attached are a sample of my workbooks and sheets.

    What I want to happen is for column F in the Sponsors worksheet in forumhelp.xlsm to sort A-Z when the cell B3 changes in the New Hires worksheet. Based on the B3 value it will change the values in column F. I have them change to "zzzz" in column F to rid the problem of "Cells are not empty if they contain functions" issue. Not sure if I'm going about this in the wrong way or not - but any help would be great. Thanks!

  • Re: Autosort on different worksheet cell change

    Uploaded forumhelp.xlsm Workbook has #REF errors in the column F formulas which makes it a bit tricky to test. However I think what you need is:

    In Worksheet "New Hires" code module:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!