Make sure they are links.
I have 2 ways of creating my list:
Getting the URLS:
What I did to compile my connections report was to sort by how many times they popped then copy and pasted the info onto excel. Took me about 5 min to do 35ish pages of 7+ers. Once in Excel I can do my own sort and what not.
I crash excel when I try to compile the info from plain view and I don't like the info how it's presented in get data for excel.
My other list I copy and pasted from my feed. The first week I did the whole feed not just none connected city's. I wanted to make sure I had all my connections on there. This one I tweak the link, because it says you got blah blah from so and so. I copy all the stuff before the city name....go to replace ... copy the info in top line....hit replace all. I have to do this 2-4 times to get the list all done.
What I did to compile my connections report was to sort by how many times they popped then copy and pasted the info onto excel. Took me about 5 min to do 35ish pages of 7+ers. Once in Excel I can do my own sort and what not.
I crash excel when I try to compile the info from plain view and I don't like the info how it's presented in get data for excel.
My other list I copy and pasted from my feed. The first week I did the whole feed not just none connected city's. I wanted to make sure I had all my connections on there. This one I tweak the link, because it says you got blah blah from so and so. I copy all the stuff before the city name....go to replace ... copy the info in top line....hit replace all. I have to do this 2-4 times to get the list all done.
My Email addy is:
Any ?'s feel free to contact me at that address. I check it about twice daily.
No comments:
Post a Comment