Search results

I hate to ask, but can you post a sample? this might be easier if I can see it....

I don't know how I'd handle this, but I wonder if you could do something like: for i = 1 to ubound(yoursourcearray) holderarray(i) = application.large(yoursourcearray,i) next i

Can you share your workbook? Short answer is yes, but I'm vexed by this statement "The problem I am having with the pivot tables is it always wants to sum the data."

Yeah. The page filters are easy. http://chandoo.org/wp/2011/08/10/mlb-pitching-stats-dashboard/ Try the above - it uses the same technique. The row filters might be a little bit trickier but it can be done. Again, the big question is do you want to filter those just in the chart or do...

Yeah: It's just a matter of how you want the filter to work that determines whether you set the user selection to filter the pivot tables themselves or if you want to do it in the chart layout area. Post an example of what you're trying to do?

which worksheet is your data on?

Afdeling Contact Type ContractantGroep Omschrijving Datum Afgehandeld Datum Beginregistratie D

So your data is all of this stuff? Afdeling Contact Type ContractantGroep Omschrijving Datum Afgehandeld Datum Beginregistratie D Datum Eindregistratie D Datum Start Behandeling Dossiernummer Eindbeslissing KBC Klant Klacht Subject KlantGroep Code KlantGroep Omschrijving Markttype Oorsprong...

Have a look at this. I threw this together over a cup of coffee just for demonstration, so nothing about it is good and/or well thought out. FWIW, you could probably do this with one pivot table if you really wanted to.

Why not do both? The pivot table bakes in really simple ways to sort and filter the data, getpivotdata() is a great way to extract data from a pivot and put it into whatever chart you want.

Ehhh....access.

sample data?

I'm trying to find some good outlook sites. Any thoughts?

No no. I can do all sorts of emailing from Excel. I'm trying to do do some straight outlook stuff. So I ganked this code: http://forum.groovypost.com/microsoft-office/conditional-auto-bcc-vba-t96912.html But I'd like to make it run conditionally based on the sender email address...

The latter. I think this would be pretty simple, I just can't seem to find resources on the interwebz.

I'm trying to ninja something together in outlook. Does anybody know of a good outlook vba resource?

I can probably help, can you share that file using dropbox or something though? That speedy share site wants me to download some crappy download manager.

I would start by: 1. go into a command prompt. 2. go to the directory where that file is. 3. type del exceldashboardwidgets.xlsx

So.....really cool gag with the chart. Awesome that it plays nice with the entire pivot table. That's a great trick. But if you spent the time setting that up, I'd think the chart itself deserves some more love. Off the top of my head: 1. Kill gridlines. (Seriously, make them go away) 2. Let's...

Why not just set up a batch file to run 7zip from the command line and rename the out files as .xls?

Depending on your needs (and I'm assuming that you have more than 3 accounts :) Also, with Narayan's method, get rid of sub totals. You can also just create a helper column in your source data like "concatenate([account]&" - " & [ Description])"

can you post a little better sample data?

Ok one more stupid question. If I want to resize the array to add new values beyond the initial transfer: how would I do so?

https://dl.dropboxusercontent.com/u/1275899/itworks.png alive!!

emmm.....: Sub nomorcumu1() Dim rTargetRange As Range Dim rSourceRange As Range Dim varSourceValues() As Variant Dim iPH As Integer Set rSourceRange = Range("b1:b1000") Set rTargetRange = Range("d1:e1000") varSourceValues = rSourceRange.Value For iPH = 1 To UBound(varSourceValues) If...