Transfer data from datagridview into a formatted excel

See more:

VB

MS-Excel

DataGridView

Good Morning.

I hope posting this question will lead me into the right way.. TYSM in advance.
I have a program in VB.Net and it looks like this.

http://i.stack.imgur.com/c2Oc3.png[^]

Please focus on the Following because it is the Important.

Branch (Combobox)
Location (Combobox)
Delivery Date (DateTimePicker)

Columns in Datagridview

Description
RequestedQty
UOM
Unit Price
Total
Remarks

The reason why I focus the readers on the `controls` above is because of this.
I have an excel file and it looks like this.

File Name: SR Transmittal
Sheet Name: Transmittal Form

http://i.stack.imgur.com/DsKQX.png[^]


Please Ignore the data on the excel.

Here is my question..

Is it possible that every time i click the button `Print Final Transmittal` the Data from my VB.Net program will transfer in the excel i created? (E.g: Find the Excel in designated Folder Location) and put the data in it?

Like this (Format where the Data will be putted)

http://i.stack.imgur.com/z89mX.png[^]

Seriously I dont know how to do this and I feel sorry for that. As of now if your looking something in my question, the best i can give is the linked of the excel so you can test it and lessen the burden that you may have while testing it.

SR Transmittal.xlsx - Google Drive[^]

I hope someone may help me. THANK YOU SO MUCH FOR FUTURE HELP..

What I have tried:

As of now nothing because i dont know how to make it