Hello,
I am trying to setup a macro that will use the filename to populate the worksheet. Our system auto creates a filename that has a QT#, then customer name, job name and random notes after that. I am looking for help to fill cell A1 with the filename (without filepath) and use that to fill in B1 (QT#), C1(Customer), D1(job). The length of each varies, but the dash [-] is consistent and auto created.
sample filename: QT12345-customer-job-etc-etc
I am going to use these to format the worksheets header and footer, and as a reference when this sheet gets reformatted for another department.
Any help would be appreciated.
I am trying to setup a macro that will use the filename to populate the worksheet. Our system auto creates a filename that has a QT#, then customer name, job name and random notes after that. I am looking for help to fill cell A1 with the filename (without filepath) and use that to fill in B1 (QT#), C1(Customer), D1(job). The length of each varies, but the dash [-] is consistent and auto created.
sample filename: QT12345-customer-job-etc-etc
I am going to use these to format the worksheets header and footer, and as a reference when this sheet gets reformatted for another department.
Any help would be appreciated.