CFABS UK specialists in commission reconciliation recovery have teamed with Connekt Technologies to bring you this handy tool based on the excel index formula to give you the quickest solution without coding knowledge to link prices from a commission matrix grid against product descriptions on another excel file / export. The use of this tool is not necessarily limited to linking in prices from a commission matrix grid, it can be a useful tool for linking information from any excel grid into any other excel document which uses two columns that have common names which relate to the grid header and row descriptions, and where the user wants to use these to extract the corresponding value on the grid on the other excel worksheet. No coding is required, simply follow the prompts of the simple wizard designed to help you with this task. 1. First you can drag and drop or load your commission matrix excel file into the wizard screen, 2. then follow the next wizard prompt to drag and drop or load your company sales log excel file, 3. on the second to last prompt you use a couple of simple dropdown menus to select the company sales log headers which relate to the headings and rows in the matrix 4. on the last prompt decide whether you want the matrix results to appear in a column on your existing company sales log spreadsheet, or whether you want to export the findings to a new spreadsheet. For somebody to do this operation visually with limited coding knowledge or ability would take hours, even days depending on the size of the excel spreadsheet, this solution makes the exercise simple and quick The operation may take a coder who is familiar with the excel index formula a few minutes to do. This tool makes it a quick clean operation
Comments not found