Hi Maruzio I thought you wanted 16 fields that's why I changed to 16. Attached will work for 15 fields. Sunny
Hello Maruzio I have attached the modified file. I have included an import text function. Enjoy Sunny
Hello Maruzio There are a few problems that I discovered. 1) Your text file data is inconsistent. Record 1 and 2 contains only 15 fields but ...
Hi Maurizio Not too sure if I understood your problem correctly i.e. add data is OK, viewing data is not OK. You can give the attached a try. I ...
Hi Prescott There is nothing wrong in adding a dummy value to the chart like what you did. If your data comes from a Pivot Table (and from your ...
Hi Meyanui Please refer attachment. I would recommend you follow Mynda's advice and capture your data in a tabular format. It will be easier to...
Hi David See if this is what you require. It contains a macro (CreateWS) that will create a copy of the template for each vendor, rename it and ...
Hi David I noticed a lot of inconsistency in the Vendor's name (some with full stop and some have none etc) and this will cause problems when you s...
Hi David See of this is sufficient for you. It involves creating a Pivot Table. 1 Create a PivotT able 2 Drop the Vendor Name 1 in...
Hi David Post some sample data. It will be easier for other members to help. Sunny
Hi elf If you can post some examples (the more examples the better) of what you enter and their expected results in an attachment, it would be easi...
Hi Shelley There is also another button at cell H20 named STEMI that is also part of the group that is linked to cell V24. You can see it's link...
Hi Shelley I believe your issue is you have multiple group boxes. They are hidden so you are unable to see them. I have un-hidden them so you ca...
Hi Meyanui If you are referring to the result, then just cut which ever you want and paste it into column G (Remarks) It would be good if you ca...
Hi SRICE831 See if this is what you are looking for (refer attachment). Can you elaborate more on "automatically separate the OT"? Give some exa...