Search results

Hi, I am using date filters(Pivot). When I choose "xxxx Week" filter, it looks like the sunday is the first day of the week. Is there a setting to change to Monday as the week starting day? I tried "region and language" setting under windows control panel but it didn't work... thanks

Pivot doesn't let you add twice...

I even tried on the sample file from contextures. I moved Report Filter field down to Row labels and it did not work...isn't the code looking at the fields that are under Report Filter?..

DEPARTMENT is already moved to Row Labels and there is no crash...the code just doesn't work. I am assuming the code is looking for REPORT FILTER, not row labels?...

Correct. I am moving DEPARTMENT(which used to be the report filter) to Row Labels for both pivots. There is no error/crash from VBA...it just doesn't change the filtering for both. thanks

Hi,Luke I know below code(from contextures.com) looks thru all worksheets and stuff but... Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim wsMain As Worksheet Dim ws As Worksheet Dim ptMain As PivotTable Dim pt As PivotTable Dim pfMain As PivotField Dim pf As PivotField...

Hello experts... I've been using a code that changes the filtering on multiple pivots when one is changed and it worked great. But I need to move the report filter = DEPARTMENT down to row labels. so the code no longer works. Could you guys help me with VBA code please?... I have 2...

Hello masters... I need to do 1. Find cells with value = 0 on column B 2. hide the rows with those cells thank you

My issue is the A1 part, not "[Your book.xls]'My Sheet'!X1"... Isn't circular reference error coming from A1 since it cannot look at itself? I want to be able to click the employee number(whatever the number that's already in A1) and it jumps to salary(X1).

hello all, column A contains employee numbers column X contains employee's salary amount I need hyperlink to employee's salary when employee number is clicked(same row) I am getting circular reference error when I do this... =hyperlink(X1,A1) thanks

Good day all I have raw data and turned it into a TABLE. then I created a pivot table from it. then I filter out something from the TABLE. It's now hiding some rows. But the pivot table does not reflect that filtered info from the table...it's also reading rows that are hiding. How...

Luke, =$A1<>$B1 worked.... I knew it was something simple... I wasn't necessarily looking for "1"...just highlight the row with 2 different numbers thank you

sorry, Luke..it's not working I am wanting to compare both A column and B column(per row), and if A and B are different, highlight both cells thanks

A B 1 1 1 2 <-highlight these 2 cells 1 1 1 3 <-highlight these 2 cells 1 1 Sorry, maybe i wasn't clear...i want to do above

Hi, I have below data. A B 1 1 1 2 1 2 3 1 1 4 1 3 5 1 1 I need to highlight A2+B2 and A4+B4 in red because they are different(unique). I have been selecting A1+B1 and doing conditional formating(unique value) and using format painter to copy the format by clicking each...

the thing is I am not importing data...it's an SAP report that gets "refreshed" all the time..so I can't really seperate the apostrophe. Once the report is refreshed, it overwrites any editing you've made.

Hi, I am using a formula =sumifs(x:x,y:y,">'1/1/2012") to sum up the amounts after 1/1/2012 However, the date column(y:y) contains an apostrophe in front of the date which stops excel from reading as a date. Actually, whole worksheet contains the apostrophe except the amount column...