Trying to sort Data but Formula not triggering Worksheet_Change.

[joepro7]

Hello all,

I am trying to sort Raw data from one workbook and sort it in another. The problem I am encountering is when a new value is inputted in the first workbook, it doesn't trigger a ws_change in the second workbook so my code does not run.

I am trying to do this through VBA since I don't think this can be done by a normal sort and update upon a new value or value change. here is my sample code:

sample sort code.png

I have tried to use WS_Calculate instead since that triggers, however there is no "target" so I don't know where to sort.

any help or advice or a different perspective on this problem would be helpful.

( I am pretty new to VBA so it might be an error on my part).

Thank you

[AlphaFrog]

Use Worksheet_Change on the Bulk Data sheet, but sort the other sheet in that procedure since you know it just changed based on the bulk data sheet target cell.