Hi,
I have a worksheet and I have named some ranges for some cells in the in, worksheet. (I did it by right click on the cell and choose Name a Range.... and gave a name for the cell.)
Now i have a xml which contains nodes with the same name as the name of the range. Now I want to populate values in the sheets cell from the xml for each range that is named sheet .
For eg:
Cells in the worksheet have a namerange as bookid and bookname.
Now for those cells i want to store 100, abcd respectively.
I can for loop each node in the xml , but i dont want to hardcode bookid, bookname in the for each loop for the node name and also range name, eg
How can i achieve this??
Bookmarks