I’m trying to compile data from multiple XML files into 1 Excel file with the data separated by tabs. Each tab in the Excel file would represent 1 XML file. How to I set that up? In the current setup, every time I import a XML file, regardless of which tab I’m working in, the data overrides all of the other data in all of the tabs. I’m trying to avoid working in multiple files, copying and pasting. Any help would be greatly appreciated.
Last edited:
