Search results

I have one. It may take a little while to find, because of work projects. ________ Buy air one vaporizer

This is where Pivot Tables can be frustrating. In fact, two years ago after reading and using chapter 12 of VBA and Macros for MS Excel by Bill Jelen and Tracy Syrstad, I have often used VBA for creating Pivot Tables and setting up formulas based on a copy of the Pivot Table, and final...

Yes, look at post #6 that describes how I did it. ________ Toyota fortuner

Actually, numbers are formatted two different ways. If you want a little extra, then use the comma format button, and you will get the increased space at the right side with proper alignment. ________ Vortec engine

On the toolbar, there is a button which increases Indent. Try that ________ Dc marijuana dispensary

Here is the completed Pivot. Is this what you wanted? ________ Bmw M5 (E34) History

Yes, that can be done. Select cell E6, then on the Pivot Table toolbar, on the dropdown on the far left (or top), where it says "Pivot Table", choose Formulas > Calculated field. In the resulting window, put a name for the field in the first box, in the one below that will have the formula, use...

So, in your example, you want E5/E6 (81/2385)? ________ Hawaii Marijuana Dispensary

Howdy. Can you provide a small sample of dummy data, and then a mockup of what you want? ________ Jailbroken

Howdy. Is this correct? (Range("ColA")(txtRow.Text).Value) ________ Ordinary Life Insurance Forums

Howdy. Two books are essential in this: Excel VBA Power Programming by John Walkenbach VBA and Macros for MS Excel by Bill Jelen [Mr. Excel] and Tracy Syrstad Also, if you are in London, there are quite a few Excel MVP's that would know of training. Check out Patrick O'Beirne, with schedules...

If I understand correctly, you could use VBA to copy, PasteSpecial Values to another worksheet, then delete all rows with value 0 or "". ________ Weed vaporizers

My only formal computer training was in college - a course on Fortran IV on an IBM 360 in 1968. I am self-taught (books and forums) in both Excel and Access - perhaps it shows. ;) My first Access project was literally trying things until they worked, then eventually having someone check and...

Howdy. Are you referring to ListBox or Combobox? ________ Hotbox vaporizers

Actually, I put graphs (charts) on separate worksheets from the data (but not a chartsheet). I make one cell large to hold the entire graph. You can make the chart fit exactly to the cell, by selecting the chart, then holding down the ALT key and move the edge to match the edge of the cell (with...

Howdy. Rather than use the title box, use a textbox linked to a cell. This will allow it to be dynamic and allows much more flexibility in formatting. ________ Mercedes-benz s-class

As old as I am, I need all the help I can get to understand. ;) My question remains, how can Excel determine that there is a change in H7, H22, H51? Is the original value supposed to be stored somewhere to make that comparison? If so, how can you determine when that will be? It seems as if the...

Howdy. Here is one approach, probably more than you want, but you could modify. You see only the Intro worksheet (which would be your question worksheet). Once you fill in the questions, then you can use a button to trigger the unhiding of the appropriate worksheets. On this sample I have the...

Howdy. So these values in column D automatically change when the data changes? How are you wanting to determine that change? By formula? A different worksheet? How often are the values changed? You reference by formula to the worksheet market_markups_02_03_07.xls. In other words, how can Excel...

Howdy, and welcome. Can you provide a small sample of the workbook and then zip it? ________ VAPORIZERS