Search results

If you created the Pivot Table with VBA right after opening, then you could have it built in. I don't have time to look for the code, but again, check chapter 12 of VBA and Macros for MS Excel for some code. ________ Mercury sable specifications

Howdy. :Pivot Table caches tend to stay put. You might be better off deleting the Pivot Table and starting over, so that all "old" data setups can bee deleted and you only have the latest data. That is why in VBA, you clear the cache and setup a new Pivot on the fly, to avoid the congestion...

Howdy. UDFs are not automatic. So you need to write some VBA code (probably one line would do it) to be triggered with any change in the worksheet. ________ CHRYSLER RFE TRANSMISSION SPECIFICATIONS

I checked in that book I mentioned in the post above. If you look at pages 256-257 and modify the setup you will get exactly what you want. I had setup something like that about a year ago. Note, rather than use blanks for no data in those columns that have only one stack, it would be better to...

John Walkenbach has some samples in his book Excel Charts, chapters 7 and 8. You might want to look there. ________ New Yorker

Just as a note on Pivot tables with VBA, chapter 12 of VBA and Macros for MS Excel by Bill Jelen (Mr. Excel), et al, is a superb helper, in which you can create code on the fly (with automatic resizing, etc.). Code samples provided. Once I began using it in VBA I seldom went back to creating PT...

Howdy, Check out the knowledge articles at www.vbaexpress.com Some of this is already written with directions on how to setup and use. ________ 360 GTC

Howdy. It would help if you could post this in an actual Excel file and attach it (it doesn't work too well to try a setup using the board itself). That way we can provide a working solution for you. ________ Hash Honey Oil

I live in Missouri (center of US), but in my traveling since becoming sem president (April 1), I have been in California (twice), Kansas, Iowa, Minnesota, Illinois, Indiana, Tennessee, Kentucky, Georgia, Florida. I just got home last night, and I go back to Indiana (via Iowa/Illinois) Saturday...

Use the TEXT function, and then you can specify whatever format you want. ________ New jersey medical marijuana dispensaries

Um, well explained, sorta... :D Howdy, Brian! ________ Mazda h platform picture

Howdy. I can't open the document right now - traveling with access to Excel.... but it is often better to put formulas in the original table. Two other approaches: 1. Set up the Pivot Table, then use formulas to draw data from Pivot (may be longer) 2. Write VBA code for Pivot Tables, then...

Brian, that is a function of the board software. I have run into that several times on many boards. ________ Toyota 7

Ah, I just a have a few minutes on the net. What a thrill it is for me to see you take the direction and advice and make it work!! The joy of teaching! You have made my day!!!! I am currently President of our Seminary, but primarily traveling and training those who are already pastors. For me...

At least now you know where to search for a solution. I'm sorry I can't help you further because I no longer have access to XL and VBA. I will check two VBA books tonight to see what I can find for you. ________ Yamaha Cp300 Specifications

No, no. Check to see whether the range is, in fact, being selected. So take this Range("A3", "AL3").End(xlDown).Locked = True and modify it to this. Try this and see what happens when you step through using F5 (helps to have Excel and VBA both visible, so arrange windows to check)...

I guess I would need more info on the scoring then to effectively change it. Sorry I couldn't help you more. BTW, I will be traveling with limited access to internet this week, so perhaps others might have other ideas. ________ ULTIMATE FIGHTER

Howdy. I think when you use the End(xlDown) that you need to select the range first. With the Range, the selection is inherent in the argument. I could be wrong, I'm working only from memory. ________ Buy Vaporizers

Try moving the rank numbers up or down one cell (be sure that you range still includes everything needed. ________ TOYOTA R TRANSMISSION

Not sure I understand what you mean by "return accurate score values". Couple of notes on the use of MATCH (and Lookup formulas). 1) If TRUE is the last argument, then the formula returns if not an exact match, then the closet value less than that. 2) The #N/A for score 1, indicates that there...