Recent content by JesseH77

Dutch, fairly achievable but might not be as useful as you would hope. The code below will do what you want but needs to go in the Workbook code, open the VBA editor, double click on "ThisWorkbook" and paste it in there. Then go to tools, references and put a check in "Microsoft forms 2.0...

Collock, an effective way of doing this is to use offset and match =INDEX(A:Z,MATCH(A5,6:6,0),MATCH(A6,B:B,0)) I'm using made up ranges but the gist is replace A:Z with the range of your table, I like to use entire columns, makes it easier to read. The first match finds the row from your...

Mark, code posted here won't work in Office Mac 2004. The upcoming Office Mac 2011 is the first Office Mac to support the same VBA model as the PC version. I'm afraid you'll have to look for some Applescript code that will work if it's even possible or a third party utility that can output it...

It's not but use his examples and download the custom UI editor and try it. Once you get in the thick of it a little trial and error will get you there. Once you have it though your work mates will think you're super cool. Jesse

For that matter when you create the pivot table in the "Table/Range" field just select entire columns, then when you refresh the data any new rows will automatically be included. The only challenge you'll have is if you have filters they will not automatically select the new members. Jesse

I do this all the time and wrote a macro to do it for me. Takes the selection and fills every blank cell with the cell above it. Sub FillBlankLines() ScreenUpdating = False Dim rngSelection As Range Dim rngCell As Range Set rngSelection = Selection For Each rngCell In rngSelection If...

Ron de Bruin has an excellent set of articles on the subject. http://www.rondebruin.nl/ribbon.htm Jesse

Bullet charts are nice but work best when used as isolated measurements or when reporting different measurement in the same group. I would go with the poster's suggested. I'd use a stacked bar chart with zero gap to create the band levels and use a line chart to display the values. Given...

So I narrowed it down. I have an Addin that has all my tools. When the code is in the addin it behaves exactly as above, fails when I change input type. When I copy the same code to a workbook module and change the names to make them unique, it works exactly like I'd expect. So now the...

I'm using Excel 2007. I'll try it at home tonight and see if I get the same. I'm glad it's working for you guys, makes me feel less crazy. Jesse

I'm trying to write a sub that will accept either text or a value as a parameter and have encountered some behavior I don't understand. If I take this code: Sub TestInput(strText As Variant) MsgBox VarType(strText) End Sub and call it from the immediate window TestInput(53) I get...

I use this when I break a pivot table from an OLAP source and want to create a new pivot table. This code takes whatever your selection is and fills down until it hits a cell with values. Works great when you have multiple sets of blanks that you want filled from above. Sub FillBlankLines()...

If you want a formula that you will always concatenate the three adjacent cells that would be fairly easy. That's not what you're asking but might serve as a work around for you. One such formula would be...

I prefer "Employed" :) Jesse

It sounds like you want to be able to output to text with a custom delimiter. I don't think any of the built in save as options will let you specify delimiter. Chip Pearson has some code on outputting to text and specifying delimiter that's I've used before to great success...