Learning how to make macros and semi read VB code - just enough to make tweaks to fit my exact needs - is one of the most useful skills I have developed.

- Thread starter Fingolfin
- Start date

Learning how to make macros and semi read VB code - just enough to make tweaks to fit my exact needs - is one of the most useful skills I have developed.

But you could be doing it so much better!Haha I just read this whole thread, and the only thing I've ever used Excel for is to keep track of my beer.

I have no idea what I'm doing.

Probably true. I'm a total idiot with Excel. I was proud of myself for figuring out how to Sum my total bottles #. I'm sure I'm doing unnecessary steps with everything I do, but I have no time to figure this out.But you could be doing it so much better!

We will figure it out for you. Hence, this thread.Probably true. I'm a total idiot with Excel. I was proud of myself for figuring out how to Sum my total bottles #. I'm sure I'm doing unnecessary steps with everything I do, but I have no time to figure this out.

wat

Srs, what is OBDC?

Open Database Connectivity?wat

Srs, what is OBDC?

I have a spreadsheet set up with a magic button. I could just ask the guy who made it.

Here's a slice of the data I'm working with (I've got a 1000+ rows):

I've got multiple entries for the same site number in column A and I need one consolidated total of the corresponding column B amounts for each site number. It doesn't sound like it's difficult but I'm banging my head against my desk today on this.

Thank you for any help Excel Wizards of TalkBeer!

A pivot table will do the trick for you. Email me the sheet: kwmiles@gmail.com, I'll send back with Pivot done and then find a tutorial so you can do this in the future.

Here's a slice of the data I'm working with (I've got a 1000+ rows):

I've got multiple entries for the same site number in column A and I need one consolidated total of the corresponding column B amounts for each site number. It doesn't sound like it's difficult but I'm banging my head against my desk today on this.

Thank you for any help Excel Wizards of TalkBeer!

Teach a man to fish and all.

EDIT: inb4, "IF functions will work, too." Yeah, but pivot table is so easy...

Pivot table will work - likely the easiest way.

Here's a slice of the data I'm working with (I've got a 1000+ rows):

I've got multiple entries for the same site number in column A and I need one consolidated total of the corresponding column B amounts for each site number. It doesn't sound like it's difficult but I'm banging my head against my desk today on this.

Thank you for any help Excel Wizards of TalkBeer!

Another option (just for learnin' sake) is: highlight all your data, go to the Data tab/menu and select Subtotal. It will add a subtotal at the end of each group and a grand total at the bottom. Then you can use the plus/minus bars that will pop up on the left to hide everything but the totals (and copy/paste to a new sheet if you don't want the data behind it). I think Column A will have to be sorted first or it may sort it for you - don't remember off hand.

Yeah, pivot table def fastestA pivot table will do the trick for you. Email me the sheet: kwmiles@gmail.com, I'll send back with Pivot done and then find a tutorial so you can do this in the future.

Teach a man to fish and all.

EDIT: inb4, "IF functions will work, too." Yeah, but pivot table is so easy...

Ah, good call. I rarely use subtotals but it works. Pivots are just so damn fast and ridiculously good-looking.Pivot table will work - likely the easiest way.

Another option (just for learnin' sake) is: highlight all your data, go to the Data tab/menu and select Subtotal. It will add a subtotal at the end of each group and a grand total at the bottom. Then you can use the plus/minus bars that will pop up on the left to hide everything but the totals (and copy/paste to a new sheet if you don't want the data behind it). I think Column A will have to be sorted first or it may sort it for you - don't remember off hand.

... Excel Wizards ...

Just got back from a meeting, will send it over soon. No problem!

EDIT:

Short and sweet. Let me know if you need anything else, Lognar

Last edited:

Look here folks, the first instance of someone actually getting work done, while wasting time on talkbeer.Just got back from a meeting, will send it over soon. No problem!

EDIT:

Short and sweet. Let me know if you need anything else, Lognar

2