VBA code auto sort

rishikanjani

New Member
Joined
Feb 12, 2018
Messages
2
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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,224,845
Messages
6,181,298
Members
453,030
Latest member
PG626

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top