Hello, first of all thank you very much for taking the time to look at my problem. I have had a macro made by the forum moderator "Leith Ross". Its function is to extract data from titles in received spreadsheets based on recognised patterns and paste it adjacent to the cells within the datasets below. The pattern codes are within the macro.
In the attached spread sheet the macro does almost everything it needs to do, except it currently recognises (#)
in pattern 2 and 3. In my example spreadsheet "#" was supposed to represent a number. In pattern 2 this number is a single digit between 0 and 9. In pattern 3 the number can be 1 or 2 digits. Also this pattern looks for "TT" i believe, in the example spreadsheet the TT represents any letters or text there.
I have edited dataset two to contain more representative data. That hopefully can also be split by the amended macro.
Many thanks for any help
All the best
Alan
Bookmarks