Export Folder and create a File name as you type in Excel based on column Data

Hello everyone.

I have an Invoice excel sheet (online version) and as I create new invoice, I then create a folder in my desktop with the file name as the invoice number where I store the supporting documents such as delivery note , client PO etc.

Now I would like to automate this process such that when I type in the invoice details in excel, a folder should be created in my computer with the file name based on the invoice number.
For example, if I were to book an invoice FZE 7844 a folder should be created in my computer with the file name FZE 7844.
Please note it should be created as the invoice number is booked and not based on a list.


I have attached two screenshots for clear understanding.

1. Excel file - A sample of how I book the invoices.
2. Screenshot - How I would like the folder to look. The file name was typed manually based on Column B & D & E as per the excel file. Please check advise if this is possible to automate this with a formula or VBA?

Regards
Kunal Naik

Maybe something like this in the change event?

Please Login or Register  to view this content.

Thank you. But can this be applied to Excel Online version?