Hi, I desperately need help and I have tried most of the recommendations I have found but either I am not doing it correctly (which is usually the case) or they don't work for my situation. I have a spreadsheet that is pulled from a data source in CSV format which includes over 10,000 rows. I need to show the rows that ONLY start with REQ in column A (CaseName) and have the rows that start with JOB_, PRJ_ and CMP_ in column A deleted or not shown (hidden) through autofilter.
I tried to record a macro while manually attempting to use the autofilter process but it gave me an error message "Too many line continuations" due to what I assume is all the '_' in the cells. Is there any way to get around this so that I can show ONLY the rows that begin with REQ in column A? This report is manually generated three times daily and this is the last step in automating the process so that I will no longer have to do any of the editing manually.
Thank you in advance, I really appreciate any help you can give or point me in a better direction.
Thank you greatly, I truly appreciate it!!
I tried to record a macro while manually attempting to use the autofilter process but it gave me an error message "Too many line continuations" due to what I assume is all the '_' in the cells. Is there any way to get around this so that I can show ONLY the rows that begin with REQ in column A? This report is manually generated three times daily and this is the last step in automating the process so that I will no longer have to do any of the editing manually.
Thank you in advance, I really appreciate any help you can give or point me in a better direction.
Thank you greatly, I truly appreciate it!!