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.

[TABLE="width: 746"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Date
[/TD]
[TD]Region
[/TD]
[TD]Issue Type
[/TD]
[TD]Resolution
[/TD]
[TD]Reference no.
[/TD]
[TD]Agent Name
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2-Mar-18
[/TD]
[TD]East
[/TD]
[TD]Packaging
[/TD]
[TD][/TD]
[TD][/TD]
[TD]AAA
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]16-Mar-18
[/TD]
[TD]west
[/TD]
[TD]Delivery
[/TD]
[TD][/TD]
[TD][/TD]
[TD]BBB
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]23-Mar-18
[/TD]
[TD]north
[/TD]
[TD]Supply
[/TD]
[TD][/TD]
[TD][/TD]
[TD]AAA
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]23-Mar-18
[/TD]
[TD]South
[/TD]
[TD]Packaging
[/TD]
[TD][/TD]
[TD][/TD]
[TD]CCC
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]23-Mar-18
[/TD]
[TD]East
[/TD]
[TD]Purchase
[/TD]
[TD][/TD]
[TD][/TD]
[TD]AAA
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]23-Mar-18
[/TD]
[TD]East
[/TD]
[TD]Billing
[/TD]
[TD][/TD]
[TD][/TD]
[TD]CCC
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]23-Mar-18
[/TD]
[TD]East
[/TD]
[TD]Packaging
[/TD]
[TD][/TD]
[TD][/TD]
[TD]BBB
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]23-Mar-18
[/TD]
[TD]East
[/TD]
[TD]Supply
[/TD]
[TD][/TD]
[TD][/TD]
[TD]CCC
[/TD]
[TD]Open
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]23-Mar-18
[/TD]
[TD]East
[/TD]
[TD]Purchase
[/TD]
[TD][/TD]
[TD][/TD]
[TD]DDD
[/TD]
[TD]Open
[/TD]
[/TR]
</tbody>[/TABLE]


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).



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

 

[RAKESH230583]

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