Search results

Hi Nebu, many thanks for your kind help. This workout is really helping to ease my pain a lot. Thanks again.

Can anyone explain what is the below code ' clientname = Sheets("Client_S").Cells(4 + Range("Clientname"), 1).Value ' mean ? What does the 4 and 1 doing ? Sub SelectClientName() On Error GoTo Err Dim p As PivotTable Dim sht As Worksheet For Each sht In...

Hi Nebu, attached is the working file that I wish to have. Please see if this can be done ? Whenever user select an option in sheet1, then filter will be apply in sheet 4 (cell B1) and sheet 3 (cell A2)

Hi guys, I would like to know if anyone can help me to build a VBA to enable me for selecting an option from the combo box/drop down list (sheet1) and then the pivot table (sheet2) and normal data table (sheet3) will be filtered accordingly ? Thanks.

Hi all, I am using macro to perform refreshing of 2 pivot tables currently. 1st pivot table is a very simple table with just a few fields on it. However when comes to the 2nd table, the data is enourmous and it is taking a very long time to open file, refresh table, etc. My selection is from...

Hi SirJB7, the password above is valid in my PC, not sure why. Can we use offset ? The series label would not be good enough in my chart as the volumes might varies from thousands to few hundred thousands. The lines are just too near. Any otherway that I can share my file?

Here is the link : Link Pwd : 100%Abc123

1st one helps, but seems to be hard to apply into my 12 months long spread table.

I can't actually. Am in the office and need to apply their rules. Its all blocked. For the legend: If I choose product A at the radio button, the legend for the last row (H16:S16) will be called Total Product A (with orange line). If i choose product B at the radio button, the legend for...

I have a variable line graph with Legend. Its reading from H11:S16 (12 months data). For H16:S16, this row's data might varies. A radio button is available to select either Product A or Product B. I have no problem to read and display the Product A data as it will show all 6 lines of data...