I am presently using Quik Link for Excel version 6.2A. I have a question concerning the =accpac formula. Here is my question: My chart of account is set up in two segments: 6 digits and 3 letters (dept). The first 4 digits refer to a G/L account while the last 2 digits refer to a subsidiairy or a division of our group. Using Quiklink with this set up to do consolidated financial statements is easy since all of the accounts of the company & the subsidiaries are included in one trial balance. Now, for year-end purposes, I need to prepare individual financial statements for every company of our group. To do so I need to use the =accpac along with the last 2 digits of the first segment. How can I do this?