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
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
