VBA Sort but a nice twist

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi guys can you help, erm this is a good one

I need to get rows of data sorted, thousands of them by col A

Data

A0001
A0002
A0005
23456
12377

but the twist I need the data say A0001 to be on row one and data A0005 to be on row 5, data 2345 on row 23456, any blanks are fine then blank they should be the entire row sorted all data on the row, not just column A
All the data is very mixed up a simple sort is ok but no rows to data number??
Any ideas guys

JITUK
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
Off the top of my head, it seems that every item has a predestined location on a new worksheet. Once done, delete the original sheet, rename the new with former's name.

The values just need to be interpreted as integers. Set up a loop that tests a value as numeric, remove the leading character if test fails, then test again until successful.

Is the data formatted as text? Cint() would be useful, then.

Does this sound about right?

_________________
This message was edited by stevebausch on 2002-11-15 06:09
 

Watch MrExcel Video

Forum statistics

Threads
1,123,488
Messages
5,601,976
Members
414,488
Latest member
rjp847

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
Top