difficult filter/sort

[Tomas mcD]

I have attached a file showing several fields with the headings starting at row1 column 1.
I would like to filter out the rows of data where the IDNumber has no blanks below them.

This is because I want to show rows wher there is an IDNumber and the blanks below because they are the IDs of people who have worked for different departments.

The original spreadsheets may have a copule of thousand rows in them.

Thanks very much for your help in this

[adeelkhan007]

use delimated txt process for that .paste data in excel and select first colum,press ALT+D+E
Then select delmated option.use space optn as target then it comes in right as oyu need

[realniceguy5000]

Hi,

can you just post an example workbook?

This text file has a lot to be desired.

I'm sure you may get someone to help you ,if you can give some good feedback.



...

[tigeravatar]

Tomas mcD,

Attached is a sample file based on the sample data you provided. It contains a button named "Filter" which is assigned to the following macro:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Tomas mcD]

I have attached a file showing several fields with the headings starting at row1 column 1.
I would like to filter out the rows of data where the IDNumber has no blanks below them.

This is because I want to show rows wher there is an IDNumber and the blanks below because they are the IDs of people who have worked for different departments.

The original spreadsheets may have a copule of thousand rows in them.

Thanks very much for your help in this

I have attached an excel spreadsheet this time

[tigeravatar]

Tomas mcD,

Based on the excel sample workbook you provided, I updated the macro to the following:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Tomas mcD]

Hi,

can you just post an example workbook?

This text file has a lot to be desired.

I'm sure you may get someone to help you ,if you can give some good feedback.



...

Thanks vry much problem solved

[Tomas mcD]

how do i mark it as solved

[tigeravatar]

1. In your original post, click "Edit"
2. Advanced
3. Change Prefix to [Solved]