I have a file that is imported containing Text in B2 "BR Southern SalesLedgerOutstandingTransactions.csv"
I would like macro to extract the txt to the left of Salesledger..... i.e "BR Southern' and copy this into AD2
Your assistance in this regard is most appreciated
I would like macro to extract the txt to the left of Salesledger..... i.e "BR Southern' and copy this into AD2
Your assistance in this regard is most appreciated