I have built a report that pulls the trial balances for numerous companies. Each company's trial balance is on a separate excel spreadsheet. Then I created a columnar report with each company listed across the columns and the account no. and amounts down the rows. Very simple standard consolidated report. But when I refresh the trial balances the Consolidated report gets messed up. How do I lock in the formatting on one spreadsheet?
I realized I wasn't being very clear. I am using vlookups on the summary worksheet to pull all the balances from the individual worksheets. This summary worksheet keeps getting refreshed and broken.
Date
Votes
3 comments
-
Jet Reports Historic Posts I do know that you need to do all the formatting in Design mode, and not in Report mode. The formatting should remain constant if done that way.
-
Jet Reports Historic Posts Try changing the number of rows in your vlookup from N to N+1 while in design mode.
-
Jet Reports Historic Posts Hi
Please share the report here if you could
Thanks N regards
Ravi
Please sign in to leave a comment.