Hi Carolyn Try changing this line of your code from xlsx to jpg/docx etc If InStr(1, AttachFile, "docx", vbTextCompare) Then In cell B4 chan...
Hi Frans Thanks for your feedback. Glad to know that we are able to help. Cheers Sunny
Here is another try with a column chart with some helper columns. If I need different colors, I will normally create different series. Hope this he...
Hi Suhail See if this helps. Please note that these are array formulas. Sunny
You could try =TEXT(A1,"mm-dd")
Hi Just a slight variation to Mynda's PivotTable solution. This will ensure that all dates begin in the 1st column and so on without any blanks ...
Try this. Sunny
There is no attachment.
Please attach some sample data and the expected results.
Hi Bob Using Frans example above but without a helper column. =SUMPRODUCT((WEEKNUM($A$6:$A$285+0,2)=F2)+0,$C$6:$C$285) Sunny
Hi Jim See if this helps. The problem is the Date in column D is text while the date in columns H and after are true dates. Not too sure if i...
Hi Andy In addition to the link above, you can also refer to this : This link contains the original code that I modified to remove blanks from th...
Hi Andy Those {} belongs to array formulas. You don't key them in. When you enter or edit such formulas, you need to press CTRL+SHIFT+ENTER inst...
Hiding Formulas 1) Select the range where the formulas are. 2) Right-click and select Format cells and select the Protection tab. 3) Tick the...
Hi Andy Give this a try. Haven't 100% tested though. Please do not touch row 1 of the Data sheet but you can hide it. You will then need to use ...