G
Guest
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
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