If you want to create a pivot table from data on different worksheets, you can use a Multiple Consolidation Ranges pivot table. However, that creates a pivot table with limited features and functionality. Last year, Excel MVP Kirill Lapin (aka KL) shared his brilliant code to create a Union query and build a fully functional [...]
 
|
If you've added comments to an Excel worksheet, you have a couple of built-in options for printing the comments. Show the comments on the worksheet, and print them as displayed. Print the list of comments at the end of the worksheet, on a separate printed page.Printing the comments on the worksheet is okay [...] Last week, I posted Bob Ryan's Excel macro for formatting a pivot table in Classic style. Bob's macro formats the first pivot table indexed on the active sheet. Dim pt As PivotTable Set pt = ActiveSheet.PivotTables(1)Ideally, you'd only have one pivot table on a worksheet, to prevent problems with overlapping, and Bob's code [...] If you're filling in an order form in Excel, you can use the VLOOKUP function to find the selling price for each item in the sales order. For example, in the screen shot below, the order form is on the Orders worksheet, and a VLOOKUP formula in column D pulls the cost from a pricing [...] It's easy to protect a worksheet in Excel, but it's not so obvious how you leave some of the cells unprotected, so users can make changes to those cells. You can follow this tutorial to learn how to do that, and maybe you'll even see the weird dialog box heading that I show below. [...] Are there files that Excel opens automatically, every time you start Excel? Something changed in your computer, and Excel files are opening automatically, and you want to get rid of them. Keep reading, to see where those files might be located, and how to stop them from opening. Also, remember to enter the Excel [...] My friend and client, Bob Ryan, from Simply Learning Excel, has just published a hands-on, no fluff, Excel book -- Simply Learning Excel 2007: Learn the Essentials in 8 Hours or Less. To celebrate the book launch, I asked Bob to share one of his favourite Excel tips with you, and you can read [...] This week, there were a couple of Excel conditional formatting questions in the blog comments. Ron asked about changing the font colour for the highest, second highest and lowest values. Guido wants to highlight values that aren't multiples of another cell's value. I'll answer the questions here, so they're easier to find. Maybe you've [...] In Monday's blog, you saw how to make simple dependent data validation drop down lists. After creating the drop downs, you added some flexibility by using the IF function in the data validation formula. Today you'll see a couple of problems that can occur when you refer to other cells in your data validation, [...] You can use data validation to create drop down lists in Excel. With a bit of Excel magic, you can create dependent drop down lists, so the selection in one drop down controls what appears in the next drop down. We'll take a quick look at how a basic dependent drop down works, [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
