First, let me say thanks to everyone who contributes their time here. You guys have been incredibly helpful and prompt in your replies. I have one final problem I need sorted out and then I can leave you all in peace. :wink: This may also be too big of a task to just ask for some quick/simple help with. I wouldn't be opposed to compensating you for your time (if the forum rules allow for that).
I am working with the following XML file: http://www.veevsvault.com/veev/guild.xml
Under the Members group, I need to extract a list of every Name that has IsOnline set to True. I need these names pasted in a horizontal row in another worksheet, with one name per cell.
I am slightly familiar with recording and using macros in Excel, so if there is an automatic way I could filter out this data, I could potentially take that route. And I am able to copy/paste the XML file into its own sheet in Excel, but if there was a way to directly extract the data from a pre-set file path that would be even better.
And that's all that I really need done. If it's not too much trouble I'd also like to replace the Name tag with its associated OfficerNotes tag, ONLY if Rank = 1, 3, or 9.
Again, I realize I'm probably asking for a lot here, so I'd understand if it's too much time to volunteer. Here is the spreadsheet I am working with, if it helps to see exactly what I'm attempting to do: http://www.veevsvault.com/veev/rift.xlsm -- I want to filter out the needed data on the Import tab, and then paste it on a new line in the Attendance tab.
Thanks for taking the time to read.
I am working with the following XML file: http://www.veevsvault.com/veev/guild.xml
Under the Members group, I need to extract a list of every Name that has IsOnline set to True. I need these names pasted in a horizontal row in another worksheet, with one name per cell.
I am slightly familiar with recording and using macros in Excel, so if there is an automatic way I could filter out this data, I could potentially take that route. And I am able to copy/paste the XML file into its own sheet in Excel, but if there was a way to directly extract the data from a pre-set file path that would be even better.
And that's all that I really need done. If it's not too much trouble I'd also like to replace the Name tag with its associated OfficerNotes tag, ONLY if Rank = 1, 3, or 9.
Again, I realize I'm probably asking for a lot here, so I'd understand if it's too much time to volunteer. Here is the spreadsheet I am working with, if it helps to see exactly what I'm attempting to do: http://www.veevsvault.com/veev/rift.xlsm -- I want to filter out the needed data on the Import tab, and then paste it on a new line in the Attendance tab.
Thanks for taking the time to read.
Last edited: