RedstoneIT
asked on
Remove all rows except ones containing selected date
Good Morning Experts;
I have an Excel Workbook that performs a series of tasks before creating a CSV file for export into Timberline.
My boss has asked that the control worksheet now remove all rows from sheet Labor_Totals_Temp except for ones containing a user prompted date. I've attached a copy of the spreadsheet in its working state. Stage 4 is the button that should trigger the search and removal of unneeded entries in sheet Labor_Totals_Temp.
Simply put the following should occur.
User clicks on Stage 4 on sheet "Controls"
User is prompted for a date in format mm/dd/yyyy
Macro goes to sheet "Labor_Totals_Temp" and deletes all rows that do NOT have the prompted date.
Regards,
Brian
Z-Master-Daily-Converter-2007---.xlsm
I have an Excel Workbook that performs a series of tasks before creating a CSV file for export into Timberline.
My boss has asked that the control worksheet now remove all rows from sheet Labor_Totals_Temp except for ones containing a user prompted date. I've attached a copy of the spreadsheet in its working state. Stage 4 is the button that should trigger the search and removal of unneeded entries in sheet Labor_Totals_Temp.
Simply put the following should occur.
User clicks on Stage 4 on sheet "Controls"
User is prompted for a date in format mm/dd/yyyy
Macro goes to sheet "Labor_Totals_Temp" and deletes all rows that do NOT have the prompted date.
Regards,
Brian
Z-Master-Daily-Converter-2007---.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.