Free download Kutools for Excel – handy Excel add-ins collection
My story:
I purchased your EXCEL tool for one reason. 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. Same job, every time, you’d think it was simple! But no. 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. 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. I then insert new lines and add them, then remap the new ones. The bit that was causing me lots of time was then working out if I had mapped them all or missed any. 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. YOUR fantastic product allows me to check ALL of them at the same time! If only I had found this years ago. It looks like you have many other interesting tools, so I will check them out when I have finished my work. Thank you so much.
