Hi All,
i have been looking for a VBA code that automatically sorts my data when it is entered/ updated. if there is a value in column I the VBA should move the row to the next row that is not blank in column I resulting in having all blank cells at the bottom. i know you can us a sort but i want it to trigger automatically upon entry can someone help me with some code or if a sort can trigger automatically this would equally work?
Thank you!
i have been looking for a VBA code that automatically sorts my data when it is entered/ updated. if there is a value in column I the VBA should move the row to the next row that is not blank in column I resulting in having all blank cells at the bottom. i know you can us a sort but i want it to trigger automatically upon entry can someone help me with some code or if a sort can trigger automatically this would equally work?
Thank you!