So I am trying to figure out how to make a search macro where you can select dates (each date is in worksheet) copy and paste the row to the cover page. excluding all "give-up" entry. The search will only be the letters in the front of symbol column (H) not the numbers.
[SOLVED]
Last edited by DAxel1259; 06-19-2018 at 04:28 PM.
Hello DAxel1259,
See if the attached workbook does what you want. I have included the code here for those who are interested.
Module1 Macro Code
Search Worksheet Macro Code
Please Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
It's perfect, but there is one issue I imported some June data but its not recognizing it, it stops on May 31st.
Hello DAxel1259,
Should not be an issue. Did you name the new sheets "Jun 1" or "June 1". The macro is set for a 3 letter month and not the full month name. Easy enough to change if you need me to.
Its set up on JUN right now, the search goes to may 31st and ends, not sure why.
Nevermind I got it to work Just needed to add a second d to mmm-d-yyyy to mmm-dd-yyyy. Thank you so much
Hello DAxel1259,
Nice work on the fix. Glad I could help.
What would happen if the format of the data changed? Say if the date column was on the AC Column?
Hello DAxel1259,
You would need to expand your search range in the macro from columns "A:T" to columns "A:AC" or I can change the the macro to use the columns in the header roe as the columns to be searched.
Im trying to use the macro on a data set where the search portion is column R, there arent any dates on column A, the Date column is AC and the data goes to CG. Also what would happen if the tabs were renamed to MMM DD YYYY ? do the Tabs also have to be in order for the macro to work?
Hello DAxel1259,
The macro was written to work with the your original layout. If you have changed the layout then the macro code must be changed also.
Is minor changes? could you help? also don't need to give-up portion anymore.
Hello DAxel1259,
Can you post a copy of the new workbook?
Here is a desensitized file
Thread Bump
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks