Excel : USerform

[RAKESH230583]

Dear All,

I have one user form details of which are getting capture in excel sheet – Sheet1(Data).

Currently with the help of userform code I am just able to put the details like below – i.e. only till its opening stage.

	A	B	C	D	E	F	G
1	Date	Region	Issue Type	Resolution	Reference no.	Agent Name	Status
2	2-Mar-18	East	Packaging			AAA	Open
3	16-Mar-18	west	Delivery			BBB	Open
4	23-Mar-18	north	Supply			AAA	Open
5	23-Mar-18	South	Packaging			CCC	Open
6	23-Mar-18	East	Purchase			AAA	Open
7	23-Mar-18	East	Billing			CCC	Open
8	23-Mar-18	East	Packaging			BBB	Open
9	23-Mar-18	East	Supply			CCC	Open
10	23-Mar-18	East	Purchase			DDD	Open

<tbody>
</tbody>

Now, I also need to update the request filled as an when I receive the regular update on above issues.

Request your assistance or expert view that how can I proceed with-it.

Below is in line with expected final output in Sheet1(Data).

	A	B	C	D	E	F	G
1	Date	Region	Issue Type	Resolution	Reference no.	Agent Name	Status
2	2-Mar-18	East	Packaging			AAA	Open
3	16-Mar-18	west	Delivery	New details updated	ABC123	BBB	Closed
4	23-Mar-18	north	Supply			AAA	Open
5	23-Mar-18	South	Packaging			CCC	Awaiting Information
6	23-Mar-18	East	Purchase		BBC456	AAA	On Hold
7	23-Mar-18	East	Billing			CCC	Open
8	23-Mar-18	East	Packaging	New delear code updated	ZYX123	BBB	Closed
9	23-Mar-18	East	Supply			CCC	Open
10	23-Mar-18	East	Purchase		AAA456	DDD	Under investigation

<tbody>
</tbody>

 

[RAKESH230583]

Please confirm I above request is not clear or required any other additional information.