complex sorting

[emymeeky]

Hi, i have an excel of around 8000 lines.


i would like to organise them by column.

column 1, the company name (it's in upper case)
column 2, the first and last name (it's usually just next to the company name on the same line)
column 3, i want the function in the company
column 4, i want the email id

text like: 26/12/2013 à contacter for example,should be deleted

It is very difficult for me to work on. Only an experienced excel guru can help me.
Waiting patiently

see attached file below

[Alf]

Perhaps like this? This macro first makes a copy of sheet1 named sheet2. Macro then removes all blank rows and rows that contains text i.e. "/" in Sheet2.

The remaining rows in Sheet2 are transposed to a new sheet called "Sorted", the "breaking point" for a new bath of rows ro transpose is the "@" sign. After all rows is transposed to sheet "Sorted", Sheet2 is deleted leaving the original sheet (Sheet1) and the sorted result in sheet "Sorted".

To test run macro "Sorter".

Alf

[jindon]

Here's my interpretation of your problem

[emymeeky]

Perhaps like this? This macro first makes a copy of sheet1 named sheet2. Macro then removes all blank rows and rows that contains text i.e. "/" in Sheet2.

The remaining rows in Sheet2 are transposed to a new sheet called "Sorted", the "breaking point" for a new bath of rows ro transpose is the "@" sign. After all rows is transposed to sheet "Sorted", Sheet2 is deleted leaving the original sheet (Sheet1) and the sorted result in sheet "Sorted".

To test run macro "Sorter".

Alf

You are really a wizard! Saved me a bunch of work!
Thanks!

[emymeeky]

Here's my interpretation of your problem

Sir.. You are really great! I must commend the simplicity of your work. You are not only accurate... you are perfect! Keep your brain oiled!
Thanks!