View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin R Kevin R is offline
external usenet poster
 
Posts: 27
Default 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