Ku Tools is one of the best and most useful I’ve ever seen. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |