Need Help with complex coding conditions
Budget: $10 – $30 USD
I am building a VBA code. So far it allows the user to click a button and select the appropriate file path. It then copies all of the rows and columns and copies and pastes them on a Sales Sheet. However, I now need my code to loop through and use conditions to determine what needs to be copied and pasted. I need the loop to check to see if AT or DC are the first two characters of the string. I then need to look between two hyphens "-" and "-" to determine if between them lies 4 or 8 numbers. If both conditions are met, I want the entire row up copied and pasted on my Sales sheet. For instance, if cell A1 contains AT8768-9879-OH I want that captured, but I do not want AT387-98OH-DC captured. Please help?