I had to go through ONE by ONE using the TRACE Dependants routine, and there are 900 lines each with 3 cells, so 2,700 to check. The bit that was causing me lots of time was then working out if I had mapped them all or missed any. I then insert new lines and add them, then remap the new ones. I have a workbook into which I put the new file, and match it to the old one, then by using TRUE / FALSE, it highlights the lines which are different. The CSV file changes every time, because if new accounts are used, it then adds those lines, and until you come to do it, you do not know which ones have been added. Same job, every time, you'd think it was simple! But no. I have to do a job every month where a Trial Balance exported from an accounts program in the form of CSV has to be mapped to specific cells in a spreadsheet which then forms a set of management accounts.

I purchased your EXCEL tool for one reason. Ku Tools is one of the best and most useful I’ve ever seen. I use Microsoft Word to write books, format the content to publish on Amazon, and have spent many hours customizing Word in order to multiply my productivity.Ībout two weeks ago, I counted the number of applications I’ve used in the last 6 months, and the total came to exactly 33. I use Excel to build templates, design business models, crunch numbers, and make projections. Once every three months I hold webinars where I teach my students how to use the high end features of high end chess database software. I have been teaching software applications for over twenty years, and spend 12 hours a day on the computer. These tools are worth their weight in gold and besides my personal experience, now I will share my background, so you can trust my recommendation. I use them every single day, because hey are all filled with tools that are guaranteed to at least double your productivity, when you are working in either Word or Excel. Ku Tools for Word, Ku Tools for Excel, and Office Tabs are the very best tools in my software library.

Free excel installation