CliffMongoloid
Well-Known Member
second cup of coffee....
3rd cup
I see what you did there.:rockin::rockin::rockin: Have fun doing vlookups.
I need beer. Time to go get some.
Nice. I will let you know. It was just sent along with an ESB. Both aren't bad beers and I think they were the better beers of the free beer I received.No. 3 is a decent IPA but No. 6 is a really good DIPA. Remind me next time we trade and I'll send you one of those.
Hmmm ... I don't recall having it. I plan on doing some more cellar clean-up this weekend so I will keep an eye out for it.
Coffee ... is it Friday yet?
A beer right now sounds amazing...
i do vlookups all day long- love em- seems like u know excel pretty well.... i have a project coming up that i have to compile about 600 different spreadsheets into 1 for the purpose of vlookups- aside from copying and pasting for hours is there a way to easily compile these into 1?
Friday is my conference call day- starting at 10am every hour on the hour until 5 pm... why they are schedualed on fridays i have no idea but its prolly why i wind up drinking so much on friday nights.
Nice. I will let you know. It was just sent along with an ESB. Both aren't bad beers and I think they were the better beers of the free beer I received.
I f'ing hate Friday conference calls to no end. As for your spreadsheets, I know there is some VB code that you can use but the code I was given long long ago didn't fully work. debugger threw an error so I ended up copying and pasting.
Though for some reason I thought vlookup could reference different files as long as they were open. vlookup was the bane of my existence in grad school then I ended up understanding it, creating a tutorial and using it everywhere. In fact, it is probably all I'm good for these days at work. :rockin:
Yeah, I use vlookup to search multiple files as well. after you enter the lookup value you choose the table array. I just select a range in another sheet by clicking and dragging. Cliff, are you using Excel 2010?
no 2013
Almost time to get my drink on.
Just something simple
Dear lord, that must be $40 or better of boozeeeeeee
My firend showed me this! French pressed proprieters w/ a wendy's baconator
enjoy!
http://www.youtube.com/watch?v=LB_vpBD413s
What a moron.
What a moron.
if you didnt laugh when he was french pressing a burger into a sought after beer, you have no sense of humor!!!!
waste of burger and beer.
only thing to save that video would be if he actually drank them all afterward.