Yeah dude, this is really cool stuff.
I've never gotten into spreadsheets, but man it's great for organizing data and I can really see how powerful having a dynamic database could be, and not just for this stuff, for anything where you need data. It's TRILL!
Anyway, yeah, if you can figure out a way to be able to select multiple cells that contain a
specific value or string, I think you could make the whole spreadsheet thing an almost one-click process.
I just spent the last few hours browsing myspace for specific criteria - women, 21-50, and within 50 miles from my area code. I went through every page and put all of the friends in a sheet and sorted out the actual viewprofile links as i went. it's taken about 5 hours because there were almost 30000 profiles, but about an hour or two into it, i had just gotten in the groove of it and it was very productive.
I took all the viewprofile links, changed them to addfriend links with the Replace feature (by far the most useful tool!), and then put HTML table tags around the links. then when I copied all that to a notepad file, i constructed an HTML/CSS table that makes the names easier to read so i can just hand it off to my buddyfriend guitarist and he can click shit all day long tomorrow. hahaha. he's gonna be FUCKING THRILLED.
Here's a screenshot of the final product:
It took a bit of extra time to make it pretty, but I feel that it's worth it in the long run to make it easier to understand and read.
I saved another copy of the HTML without the Excel information in it so I can just paste new data in and save it for another page later...
I'm pretty sure if one had a PHP database or something and were good at writing database shit, one could easily write something that fetched friend id's and generated a dynamic list that updated all the time. it would be crazy. That's a little out of my range though, I tried to mess with network database shit a few years ago and HATED it.