-
1 Attachment(s)
Setting up a check box
I would like to set up a check check box in Col A, which is in the column next to the account numbers to ensure that all the account numbers have been mapped i.e being taken into account. A trial balance is imported into my management accounts workbook each month and if any new account numbers have been added, I will be able to pick this up immediately by having a check box to see if there are any new account numbers
Your assistance in setting this up is most appreciated
-
Howard, I only see a list of the account numbers (dummy I guess). But you haven't mentioned HOW you want this to be set up. Are you saying that you want to reconcile with the new set of account numbers and have some way to figure out if any new account numbers have been added?
-
Hi Excelfox
Thanks for the reply. The data supplied was 'dummy' data. In the actual workbookbook, the existing account numbers are in column E, the Year to date values in Col G and the month to date values in Col data I. The imported account numbers is in Col EP
I would like some of of reconciling the new account numbers (imported data) to the existing account numbers
Regards
Howard