AUTO SORT

[apgmin]

In Cells T4:T500, I make the user fill the donors name, I already have a data validation for these cells to prevent duplicate entry

Now in Cells A4:A5000, I use the data validation for list range T4:t500

Can anyone please suggest a formula for T4:T500 such that when ever the user fills the donors name in this range, it gets auto sorted when pressed enter after entry, so that it will be easy for him to select the same from the list when filling Cells A4:A5000

 

[Alex Blakenburg]

Not sure if apgmin has sorted this out yet but based on his screenshot he has the macro in Module1.
footoo's macro needs to go into "Sheet2 (KALI MANDIR RECEIPTS)

Agmin double click on sheet 2 shown in green below.
It will bring up a blank sheet on the right
Move the macro from Module1 to there.

 

[footoo]

From the information provided by Agmin, it is not clear where the range T4:T500 is located.
In post #3 he mentions sheet "Receipts" but in the screenshot per post #9 there is no such sheet.
In any event, the procedure should go in the module of the sheet which contains the T4:T500 list.