Hi Anders Many time we need some luck to resolve issues, and I got lucky this time . And yes, maybe my thick glasses helped me to "see" clearer....
It is possibly a setting issue. Maybe you can try checking if your Excel Calculation Option is set to Auto or Manual. You can also look into the Fi...
Hi rocketfinger Using your original code, the PDF files generated by your macro Step_Thru_SlicerItems looks ok. The sparklines are changing for ...
Hi Shelley It would help if you could attach a sample file of what you have done. Otherwise it is hard to interpret your needs. Sunny
Hi Shazia I am using Data Validation to create the drop-down list. You can learn about it here Whenever you select a shift code, I use VLOOKUP to...
Hi Anders The calendar is in an Excel table. Row 5 is the Table header. Table header cannot contain any formula. Any formula will be converted i...
Hi Shazia Please refer to the attachment. Not sure if it will work on Excel 2016 for Mac. 1) I have added Data Validation in column E so that th...
Hi Julie Yes, you can add the total to the table. You can read more about tables here : Sunny
Hi David Instead of checking each cell for ttl (the formula will be very long and messy), I joined them together with $A4&$B4&$C4 and then ...
Hi Julie You could try using a VLOOKUP. See if this helps. Sunny
Hi David As Derek said, you need to use the "normal" CF. See if this meet your needs. Sunny
Hi Marcy Try entering =CHOOSE(COUNTIF(E3:G3,"x")+1,0,0.33,0.66,1) in cell I3. Format I3 as % Hope this helps. Sunny
Try changing it to: 'Copy data Range("P1:R11").Copy With Range("A34:E45") .PasteSpecial xlPasteValues .PasteSpecial xlPasteFormats End Wi...
Hi Mel Thanks for attaching the file as it better describe your requirements. It is more complicated than what you have described in your post ...
There is no file attached.