Error while running a custom query to clean a Trial Balance

jazzista

Member
Joined
Jan 4, 2017
Messages
50
Reaction score
0
Points
6
Excel Version(s)
Office 365
Hello: I am trying to create a function to clean very ugly Trial balances: I don't know where the error is. I think I called out the function right however I cannot clean the report. In the attached file are the 3 trial balances ( Table 1 inside the query is the clean one for Dec: I want all the Nov & Oct TB to be cleaned the same way ) and the other 2 months ( Nov & Oct).Any help would be appreciated . Thanks in advance. Regards
 

Attachments

  • function to clean Tbs.xlsx
    113.7 KB · Views: 11
Hi Rudi... T H A N K S!!! my goodness. What was I doing wrong? It worked like magic!
 
Thanks for helping me out. It works great...
 
Back
Top