Sort Filter & Create Text File
 

OK, lets see who can help me pull this one off. Here's what I need to do...

I'm starting with a large worksheet with columns A thru W. The header row
for the data is Row 5. I need to 1st sort by Column N (Status) Ascending,
2nd by Column W (Employee) Ascending, and 3rd by Column O (Date) Decending.

Next I need to have some type of prompt for the user to further filter by
selecting a specific Status, Employee, and Date from spreadsheet. After the
3 selections are made, it can delete everything above and below what meets
that criteria.

At this point Columns I J K L M Q R S T U and V can be deleted as well.

With the data remaining, I need to send it to a text (txt) file in certain
format as follows:

Cell A1 Data Cell B1 Data
C1\D1\E1 Data F1\H1 Data
Cell K1 Data G1 Data

Followed by 2 blank rows and then repeat for each row remaining in the
worksheet which contains data.

I know this is complicated one (at least for me) but any assistance is
greatly appreciated.

Kevin

Still looking for help
 

Still looking for some help on this one.

"Kevin R" wrote:

OK, lets see who can help me pull this one off. Here's what I need to do...

I'm starting with a large worksheet with columns A thru W. The header row
for the data is Row 5. I need to 1st sort by Column N (Status) Ascending,
2nd by Column W (Employee) Ascending, and 3rd by Column O (Date) Decending.

Next I need to have some type of prompt for the user to further filter by
selecting a specific Status, Employee, and Date from spreadsheet. After the
3 selections are made, it can delete everything above and below what meets
that criteria.

At this point Columns I J K L M Q R S T U and V can be deleted as well.

With the data remaining, I need to send it to a text (txt) file in certain
format as follows:

Cell A1 Data Cell B1 Data
C1\D1\E1 Data F1\H1 Data
Cell K1 Data G1 Data

Followed by 2 blank rows and then repeat for each row remaining in the
worksheet which contains data.

I know this is complicated one (at least for me) but any assistance is
greatly appreciated.

Kevin