Hi Paul If possible change your source data from W1 W2 etc to W01 W02 and so on. Sunny
Hi Dennis Email_To can only handle one address in the original code. If you have multiple addresses, you will need to add them one by one to Email_...
Hi KingTamo See if this is what you want. Sunny
Thanks for the feedback Kenneth. Glad we are able to help. Sunny
Hi Paul See if this is what you want. I am assuming you wanted a single total for an entire row irrespective of the number of columns. Hope t...
Hi Elinor Give me some sample and I will try and see what I can do. Hope it is a tabular format. Sunny
Hi David You need 1 default sheet and another sheet named January. The modified code is based on my understanding on what the OP wanted and also...
Hi Elinor I am unable to use any formulas to compute the result you wanted as the format of your raw data is not suitable. You should ensure tha...
Hi Kenneth Try this. I added the code in red. Sub InsertDuplicateSheet() ActiveSheet.Copy After:=ActiveSheet ActiveSheet.Name = InputBox("Plea...
Hi Suhail See if this is what you want. Sunny
Hi Melinda This requirement is much more difficult to do as your data is not arranged in the correct tabular format. There are merged cells in your...
Hi Matthew There is no attachment.
Hi Trish Thanks for your feedback. Glad to know you have resolved your issue. Sunny
Hi Stephen Welcome to the forum. You can change your Windows date format to mm/dd/yyyy or dd/mm/yyyy to display 2-digit day and month. Hope t...
Hi Trish Welcome to the forum. Philip Treacy had written about this in a post. You can refer the link below to get details. Hope this helps...