transport XML file info to Excel file

[Annahda]

Hello,
I work for a shipping company. I need some help with transferring some data on xml files to a specific parts in worksheets. In the drive link I am attaching there is a a file called blank. In the blank worksheet there are texts that are highlighted yellow in the NOC, Invoice and DO sheets. I need some way to add info to the yellow highlighted of these cells with info present in the xml code in the "Sheet3" of the file. I want a way so that I can do this with only putting the "AGAINTS HBL NO:- " in the cell of the NOC sheet and the other info with automatically be placed according the respective names . Can please someone help me? Excel - Google Drive

 

[Worf]

Welcome

You could start by importing the XML data as shown below. Where is the HBL information on the XML table?

Sub Anna()
Application.CutCopyMode = 0
ActiveWorkbook.Worksheets.Add
With ActiveSheet.QueryTables.Add _
(Connection:="FINDER;C:\Users\Edu\Desktop\XML.xml", Destination:=Range("$A$1"))
    .Name = "XML"
    .FieldNames = True
    .RowNumbers = False
    .RefreshOnFileOpen = False
    .BackgroundQuery = True
    .RefreshPeriod = 0
    .WebSelectionType = xlAllTables
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With
End Sub

 

[Medhat]

use power query to accomplish the task