Joined
·
2 Posts
I'm trying to auto sort a group of data in excel. Following is the example of the data that I am trying to sort -
Items Cost
A 15
B 7
C 76
D 32
E 23
F 42
G 90
H 19
For reference - Cell A2 value is 'A' and B2 is '15'. The range is A1:B9. I've tried quite a few macros but the same failed to sort my data. The workbook name is 'Book 1' and the sheet name is 'Sheet 1'.
In reality, I am trying to automate a Quality Pareto Chart but cannot share the data here for the purpose of confidentiality. Can someone please help me with this?
ray:
Items Cost
A 15
B 7
C 76
D 32
E 23
F 42
G 90
H 19
For reference - Cell A2 value is 'A' and B2 is '15'. The range is A1:B9. I've tried quite a few macros but the same failed to sort my data. The workbook name is 'Book 1' and the sheet name is 'Sheet 1'.
In reality, I am trying to automate a Quality Pareto Chart but cannot share the data here for the purpose of confidentiality. Can someone please help me with this?
ray:
