Thank you so much for the reply. It is doing what you said it would but there is another way I need the info to line up:
When I do =ImportXML(B$1,A$1)
b1 = Drudgereport.com
A1 = //tt/b/a
It automatically populates straight down the row exactly the way I want it autopopulating seperate columns without having to add extra xmlimports. The only problem is it goes on for hundreds of entries all the way down to collumn 150. Do you know how to limit the returns of the xml import to the first 50 returns or the first 50 columns? I would just enter =INDEX(ImportXML(B$1,A$1),2 in each column one by onebut googledocs limits you to only 50 xlm imports.
Thank you so much for baring with me!!!
Bookmarks