Give this a try. Not too sure if it will work under all circumstances. I am assuming that CHAR(10) is used to break the line. You may need to chang...
Hi David Glad to know it is what you wanted. Sunny
Try this
Hi Pam I don't have a problem downloading the file. Anyway here is the code. Function GetFormat(rng As Range) GetFormat = Mid(Right(rng.N...
Hi Mariya As I mentioned earlier, your original code tried to select TextBox10 which is disabled by you. So I changed it to select Textbox1 inst...
Hi Samantha I can only suggest you create a normal column chart instead of a PT chart for the last chart. It is not elegant nor flexible but sho...
Hi Pam I have 2 suggestions: 1) Filter the values by using the Search box for TB (for example) and then manually filling TB to the right of the ...
Hi Mariya Try this. I have corrected a bug in your code that will cause an error when the qty doesn't tally. It tried to select textbox10 that i...
It will depend if all countries are two-worded like in your examples. If not then it may be a bit difficult.What is the text after the country's na...
Give this a try
Try this.
Hi David Is it something like this but with a macro? Sunny
Hi Dritan There doesn't seems to be blank rows in your attachment. What do you considered to be blank? I would merge all data first then will...
Hi Debra Apologies for my ignorance of the Degree Yes, you can sort them descending. Cheers Sunny
Hi Carolyn No problem. Most important is that you found the solution that suit you needs. Cheers Sunny