Hi Azri See my example (with instructions included) Good luck Sunny
Hi Azri To create a formula with a 3-D reference in the argument, perform the following steps: Click the cell where you want to enter your 3D ...
Hi Maurizio Try this for the IMPORT. Hope this helps. Sunny
Hi Azri If your worksheets all have the same structure, perhaps you can try using 3-D summing. For example =SUM(Sheet1:Sheet3!C3) etc. The formu...
Hi Gary C7-7 will only give you a date. What is the criteria that you want applied to the result? A certain date/month/year etc? What are the ac...
Hi Karen I would normally created gauge/speedometer chart using a combination of doughnut and pie chart superimpose on top of each other (I am usin...
If you need codes, then maybe you can give this a try : Private Sub ComboBox1_Change() Dim ws As Worksheet Dim wb As Workbook Dim pt As PivotTab...
Hi Kyle Welcome to the forum. I would suggest you use a slicer instead of a combo box when dealing with Pivot Tables. You don't need codes at al...
For the Conditional formatting you can refer here:
Hi Elinor Your raw data is pretty messy (format and all) and very difficult to analyse I have added 2 helper columns to get the customer ID and...
Hi Adam See if this helps. Sunny
Try =SUBTOTAL(109,A:A) Sunny
Hi lea I am only aware of certain version of Excel that allows the deselect You can refer here for more details: Sunny
Hi Moiz Thanks for your feedback. Happy to know it is working for you. Cheers Sunny
Hi Paul You cannot have more than one Worksheet_Change event in a Worksheet. Give this code a try. It has 2 events required to track the change ...