Search results

i'll look at it. What fields do you actually want to do the charts on?

I'd give it a shot for fun. what version of excel? Do you have the data?

You'll have to set up a helper worksheet to sum values of unique ID's, and then output to your dashboard using =large(). I don't think you can easily achieve that like you have it laid out now

No. Just set up the references as relative and you'll be able to expand the formula out to the right indefinitely.

No. When you go into manage addins there's a drop down box letting you select what kind of addins to manage. Select xml.

works fine for me; try fiddling with the path and see what happens.

how is data being added?

holy shit, those things still exist: http://www.amazon.com/b?node=1193862 I have no idea why.

http://chandoo.org/excel-formulas/vlookup.shtml should help?

you have a zip drive? Are you from the 90's? Does it have a whopping 150 mb of space? You can hold at least 7 and maybe 8 mp3's on one of those. Try changing the filter to xml expansion pack and disable that. Although, it's weird I have that listed on my xppro+office 07 box too. Does the...

i just did this with vba. I'm not sure which is a bigger pita: the array megaformula or a sub to do it

.....lot of moving parts. My read: -You'd be looking at 2 or 3 seperate charts -"Several" controls with a bunch of validation. I wonder if this isn't a good job for power pivot with slicers

try to disable the actions pane 3. Just hit "go" on your second screen shot and you should be able to dump it there. The rest of those look pretty much stock.

what is it you're asking?

kinda feels like vba is the wrong tool for this. http://sourceforge.net/projects/batchrenamer/

Dim avCheck As Variant Set myrange = Range("B:B") Dim flag As Integer avCheck = myrange For i = 1 To UBound(avCheck) If avCheck(i, 1) = plant Then flag = 1 End If Next i If flag = 0 Then MsgBox "macro!" End If If flag = 1 Then MsgBox "No macro!" End If

I would add a sub at the beginning of whatever trigger. You can do a bunch of stuff: if textbox1.value = "" then msgbox "something" or select case datediff("d", date1,date2) case < 0 Same idea----just different!

It's not going to get much on the order of style points. Let me know that this works.

could also be done with query tool?

I'm not even saying this is good.

Yeah there is an area where you're trying to enforce practices on your users rather than trying to do security. I've got a project right now where I'm going to have probably 100-200 distributed users and I thought about putting a date thing on this, but after thinking about it, I'm going with...

You sure talk a lot for a guy who doesn't know English....... :) I'm playing buddy.

The only thing is, this sort of thing sometimes doesn't help as much as you think it will. I have some workbooks that 'spoil' - for example - where calculations are based on data that expires every time. I use the if old msgbox "GET THE NEW VERSION DUDE" else do whatever trick. It works...

Wrap it with an if statement?

Hi, I just realized something: I totally suck at conditional formatting. I have a report with fields: [Part] [Type] [Sales] 1 A 1000 2 B 2000 3 A 1000 I want to highlight the entire row when the type is equal to A. I know it's setting up a