How to sort using vba
Closed
gvgbabu
venkat1926
- Posts
- 5
- Registration date
- Friday September 6, 2013
- Status
- Member
- Last seen
- September 17, 2013
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- How to sort using vba
- VBA find column by name and sort ✓ - Forum - Excel
- Vba sort array by date - Forum - Excel
- Sort apps alphabetically - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
- Number to words in excel without vba ✓ - Forum - Excel
3 replies
venkat1926
Sep 17, 2013 at 02:14 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Sep 17, 2013 at 02:14 AM
the sheet will be like this and see helper column(col F)
now sort according to helper column
is this what you want.
hdng1 hdng2 hdn5 hdng4 hdng5 "helper
collumn"
1 230 450 1 301 1
2 230 450 2 340 4
7 230 450 7 350 7
65 230 450 301 501 2
67 230 450 340 502 5
71 230 450 350 546 8
129 230 450 501 701 3
131 230 450 502 702 6
135 230 450 546 747 9
by the ;by what is the logic?
now sort according to helper column
is this what you want.
hdng1 hdng2 hdn5 hdng4 hdng5 "helper
collumn"
1 230 450 1 301 1
2 230 450 2 340 4
7 230 450 7 350 7
65 230 450 301 501 2
67 230 450 340 502 5
71 230 450 350 546 8
129 230 450 501 701 3
131 230 450 502 702 6
135 230 450 546 747 9
by the ;by what is the logic?
gvgbabu
Sep 17, 2013 at 05:58 AM
- Posts
- 5
- Registration date
- Friday September 6, 2013
- Status
- Member
- Last seen
- September 17, 2013
Sep 17, 2013 at 05:58 AM
hi venkat
here i have given 9 rows data for example
actually there will be more than 1500 rows with this data
it very tedious to insert the helper column nos.
gvg
here i have given 9 rows data for example
actually there will be more than 1500 rows with this data
it very tedious to insert the helper column nos.
gvg
venkat1926
Sep 17, 2013 at 08:00 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Sep 17, 2013 at 08:00 AM
then what is the logic
what is the connection
1, 65, 129,,2,67, 131
what is the connection
1, 65, 129,,2,67, 131