Auto Sort (Descinding) based on a column header using VBA

**satish12334** · 03-06-2024, 10:18 AM

I have an excel with professional data, I want to Auto sort (descending) based on a column header (Experience), also if on entering new record it should auto sort accordingly, on completing the entries,
Column A to E, is the entry field, and Column H to J are only display columns.

Pl. help is providing the VBA code to this request.

Thank you
KSK

**bebo021999** · 03-06-2024, 11:19 PM

This code put in worksheet "Person" module, trigger any change in range A1:G5 (If the key column was column C, the last row will be last row in column C that have data)
Right click on sheet's name/ View Code, then paste below code into

Please Login or Register  to view this content.

**JEC.** · 03-07-2024, 03:42 AM

Or

Please Login or Register  to view this content.

Auto Sort (Descinding) based on a column header using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Auto Sort (Descinding) based on a column header using VBA

Re: Auto Sort (Descinding) based on a column header using VBA

Re: Auto Sort (Descinding) based on a column header using VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] A VBA Function to sort tables based upon a column header

[SOLVED] Rearrange(sort) Columns based on number in Column header string.

[SOLVED] sort based on column value before auto printing

[SOLVED] seeking VBA help to auto sort worksheet based on date in column A

[SOLVED] Sort multiple columns based on column header

how do you auto sort based on certain column

Auto Sort based on one column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions