raum, I nee some Excel Help

Bot · #21

lol @ making a tetris game...

Is adding drop-down menus available for 2000? If so, how might I go about adding one? lol

I think I'm about ready to jump ship and abandon Word. lol

#22

QUOTE(Kramer @ Feb 10 2007, 09:30 PM) lol @ making a tetris game...

Is adding drop-down menus available for 2000? If so, how might I go about adding one? lol

I think I'm about ready to jump ship and abandon Word. lol

yes, the drop down menu (i.e. a "combo box") is available through the "forms" toolbar.

check out VBA (Visual Basic for Applications) and you will see Excel has a complete programming environment in it.

Bot · #23

Ok, this combo box shit has me right confused. lol I did a quick tutorial from Google, but it didn't work like I thought it would.

I'll tell you what I want, and maybe you can tell me if it's actually possible. lol

I have my stats organized as so:

Team Name - Votes Received - Votes Allowed.

Those stats are accumulative, so say Team 1 scores 19 in Week 1, 17 in Week 2, 18 in Week 3 and 15 in Week 4, 69 would show up under Votes Received.

What I'd like to do is keep that, but add a combo box so it'll say 69 in the box, but when you click on it, a menu will drop with the scores W1 19, W2 17, W3 18, W4 15.

Is that actually possible to do?

#24

QUOTE(Kramer @ Feb 10 2007, 10:57 PM) Ok, this combo box shit has me right confused. lol I did a quick tutorial from Google, but it didn't work like I thought it would.

I'll tell you what I want, and maybe you can tell me if it's actually possible. lol

I have my stats organized as so:

Team Name - Votes Received - Votes Allowed.

Those stats are accumulative, so say Team 1 scores 19 in Week 1, 17 in Week 2, 18 in Week 3 and 15 in Week 4, 69 would show up under Votes Received.

What I'd like to do is keep that, but add a combo box so it'll say 69 in the box, but when you click on it, a menu will drop with the scores W1 19, W2 17, W3 18, W4 15.

Is that actually possible to do?

You don't need a combo box for that, its best to have a summary sheet.

Actually you could do this with a pivot table, and just "refresh data" every time you change or add new weeks.

Bot · #25

Yeah... pivot table's are something else. lol I also tried those. I'm so rusty with Excel. lol

I'll look into summary sheets.

Right now what I've done is just added comments, so when you hover your mouse over the cell with 69 the little box pops up with the scores.

#26

QUOTE(Kramer @ Feb 11 2007, 12:42 PM) Yeah... pivot table's are something else. lol I also tried those. I'm so rusty with Excel. lol

I'll look into summary sheets.

Right now what I've done is just added comments, so when you hover your mouse over the cell with 69 the little box pops up with the scores.

yo kra-fish, just hit me u with your file, and I will what I can do to maybe add its features and data to the one I made tY, so everyone can kind of work on a Semi-official format, and "be on the same page."

Bot · #27

Well actually, mine isn't for the GL. I've actually been running my own league for a couple years now. I've just recently switched to Excel. Before I was just using Word to store my data. lol

If you still want to have a look at it you can. I like to think I keep my shit organized, but I'm almost positive you could find a better way. lol

http://rapidshare.de/files/37615901/Kra ... asonIV.xls

#28

raum's a goddamn genius...

I use Excel ALL DAY, EVERY DAY and it looks like he's got me beat...lol

#29

QUOTE(BZA @ Feb 15 2007, 01:35 AM) raum's a goddamn genius...

I use Excel ALL DAY, EVERY DAY and it looks like he's got me beat...lol

Have you seen some of my excel work? Was it Ayhja's sheet, or something else?

#30

No, haven't seen anything, but it sounds like you know your shit!