murthysri272
02-23-2016, 09:33 AM
Hi,
I have a spreadsheet which is having Column A to B. I want to sort the column A as alphabetical order (So cells which are having same values should come together), so all columns should adjust with that accordingly.
can we able to achieve this scenario in VBA code? If yes, please provide me the sample code.
Sample data for the scenario is as below:
Column A Column B
KALA $58
KAZO $123.7
KA55 $23.5
CBHY $14.0
AMJ0 $99
CBHY $73.0
AMJ0 $34
KAZO $13.0
KA55 $28.5
CT00 $12
KALA $76
KL76 $34
Regards,
Sri
I have a spreadsheet which is having Column A to B. I want to sort the column A as alphabetical order (So cells which are having same values should come together), so all columns should adjust with that accordingly.
can we able to achieve this scenario in VBA code? If yes, please provide me the sample code.
Sample data for the scenario is as below:
Column A Column B
KALA $58
KAZO $123.7
KA55 $23.5
CBHY $14.0
AMJ0 $99
CBHY $73.0
AMJ0 $34
KAZO $13.0
KA55 $28.5
CT00 $12
KALA $76
KL76 $34
Regards,
Sri