Bill Williamson
Board Regular
- Joined
- Oct 7, 2019
- Messages
- 124
I have tride a few things but Im doing something wrong. I am trying to split a Workbook name such as "Aurora E341934012.xlsm"
I have my code inserting the new columns. Now I need the Customer "Aurora" in ths case name to fill column B to the last used row in column C and the
Cso# "E341934012" to fill column A to the last used row in column C". The Customer name can vary in length so can the CSO#. But the name will always be first and have a Space after it, if Better it could have an "_".
I did not include the codes I have tried, since none worked.
Thankyou for any help.
Bill Williamson
I have my code inserting the new columns. Now I need the Customer "Aurora" in ths case name to fill column B to the last used row in column C and the
Cso# "E341934012" to fill column A to the last used row in column C". The Customer name can vary in length so can the CSO#. But the name will always be first and have a Space after it, if Better it could have an "_".
I did not include the codes I have tried, since none worked.
Thankyou for any help.
Bill Williamson