Vba auto sort

[rishikanjani]

Hi all,

I'm new to this forum and was looking for a vba code for my excel to auto sort data. Please read further for the description to my excel.

My excel has 20 columns starting from A through T. Some of these are loading data from an external source and others are calculative. I have three sheets in the same format in the workbook. Also theres 6-8 cells in the U and V columns that have calculative data. But the data in U and V is not to be sorted. It has to remain as it is.

Now these 20 columns need to be automatically sorted by column O which calculates the product of 2 cells. The data is sourced real time from an RTD server and computation is on a second to second basis. I want the Column O to be sorted automatically Largest to Smallest i.e. Highest to Lowest along with the corresponding data in the rest of 19 columns. Again as i said ,column O data will change every second.

Request someone to please write a VBA for my sheets.

Thanks,

Rishi

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1043067-vba-code-auto-sort.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).


Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.