Search results

I have a large spreadsheet with a lot of data and columns. I have a pivot table to sum all that up however I want to flip all the signs in the pivot table. Meaning 300,000 should show as -300,000 and then say -6,667 should show as 6,667. Is that possible. I used the pivot table formatting...

I have a pivot table with some filters at the top. I would like to use VBA to filter the pivot table by the word in cell A1. I can do this, my only issue is I would like to Filter by Contains in the word A1. Example is the items in the pivot table fiedl are: Andrew, Lori Andrew, Tim, Lori...

I have some data that has items like Red Pen, Paper, Blue Pen etc. I want to do a SumIf based on contains a word like pen and i have this formula that works ok. =SUMIF(D4:D11,"*Pen*",E4:E11) My issue I don't want to have a hard coded word in there like Pen. I want to have a drop down in Cell...

I'm having an issue with declaring the last row # in my macro. I have a macro with this and it works but it doens't work 100% the way I want it to. I have this to get my last row. LastA = Range("D21").End(xlDown).Row Then I have this to select some cells and do some other functions that work...

I have a file with 48 tabs of data on it. I want to combine the data into 1 organized tab. (Yes I know it should have been that way from the start but I didn't create the file) I have sevearl formula's in all the cells in row 3 that are linked ='TabABC'!B3 and ='TabABC'!B4. Now each row I...

I've learned a lot about the Index Match formula on this site from articles and some questions. I'm stuck doing something like this below and wonder if it can be done. I have a data tab with Column A is City, Column B is Type, Column C is a price for Group 1, Column D is a price for group 2...

I used the Hui Rollover Technique learned on this website before to change all my numbers on a file based on what I hover over. Also I've used just the radial buttons to change data also. My question expands on that and is this possible in excel 2010. Let's say I don't want to change all my data...

I have this formula below to return me sevearl rows of data from a specs tab based on what ID is in a cell (C7, D7, etc for each column). It works great except for 1 thing. If the field I am returning on the Specs tab is blank, this formula puts a 0 instead of returning the blank. Is there...

I have 2 cells. A1 contains a Category (Facilities), and A2 contains the date (September 14, 2012) when a I a formula to combine them together with some text, the date comes out as 41666 instead of Septeber 30, 2012 in the text. =A1&"as of"&A2 gives me Facilities as of 41166. How can it...

I have this simple code below. It's using the worksheet change function and everytime the value in D2 is changed, then the pivot table gets updated and then I want to select a cell on another sheet. The code works great in the begining but the error is when I try to select Sheet2 then Range B1...

Can a pivot table be updated via code whenever a cell changes a value but the value is not changed by any button pushing or click event? I've utilized the Hui rolloever technique for charting from the chadoo site with the Hyperlinks to change the charts. I built extra steps off that hyperlink...

I'm using excel 2007, and I have a pivot table with a field for country. Most of my records have the country populated like United States,Canada or Canada,Spain,China in the field. Is there a way to filter the pivot table field using Contains? I want to see only items containing say Canada in...

I have a question. How can I display the top and low numbers that a cell falls within of a predetermined tier. Example D1 = 500 D2 = 1000 D3 = 1500 D4 = 2000 D5 = 5000 D6 = 10,000 I want to put a formula which will tell me between those numbers where it falls, so I can use a vlookup to...

I have a pivot table and i recorded a macro to update it. SImple code of ActiveSheet.PivotTables("PivotTable4").PivotCache.Refresh And after several days of testing and running that little code, now it wants to debug and gives me a error. The pivot table hasn't moved and is still named...

I have a waterfall chart that shows 5 data points in the waterfall. The first 3 are Approved, In-Progress, Not Started that all step up (always have values >0). My next block is a Variance, and the ending point block is my Target. My question is about the variance block. This is the...

I learned a lot from your dashboard stuff and have been using the hyperlink chart with some adapations. It is awesome. I have a question about enhacing my dashboard. I'm stuck trying to figure out a good forula to do this without VBA. Is this possible what i'm trying to do, or even if my data...

I have a table which the amount of rows changes each month. I have about 10 columns on it always the same. Column A is a project ID. Sevearl rows can contain the same project id. I want to keep my file size down. Is there any way to copy say Columns C-H anytime Column A contains a certain...

have several tabs in my workbok with macros in the file. I want to protect my worksheets so users can't change them only use the functions on it. I found this code which protected all my worksheets and worked great. The sheets where protected and my macro's ran in the background without any...

I have this code that updates a pivot table filter based on a manager name. My problem is when the cell value in C3 = All, is there is no manager name called All. How can I add a line of code to clear the filter. I know how to write the clear filter but I don't know how to this. When C3 = All...

is it possible to have a Combo Box display text and not a number in the cell link? I know you can utimately use a index formula to turn that number into text. I have a column of Salesperson. The combo box is dynamic to feed off something else to show you only certain salesperson. Anyway to...

I'm able to update a pivot table I have with VB code based on a value I put into my field. I'm using this code. It makes me able to change the filter on my name field. ActiveSheet.PivotTables("PivotTable2").PivotFields("Name").PivotFilters _ .Add Type:=xlCaptionEquals, Value1:= "In-Progess"...

I have a pivot table with 4 row labels of categories of data (columns A-D). Then I have 5 fields of summary data by region. Columns E-I. Those are in the values and all are set to SUM. The first time I sort my pivot table it works correctly. I sort it by Colum H whihc is North America. It...

I have a stacked column chart. Primary Axis I have Target #. The column is shaded white with a black border Secondary Axis I have 3 numbers that are stacked to show performace vs the target. They are shaded red, yellow, blue. The gap for the Target is wider so I can see the border. My...

I was reading the dashboard section you have on the table scrolling and sorting. It it awesome and will work for something I doing. I do have a question about is it possible ot add something and how to do it. I used your stock table on your website here...