Populate Report Automatically

penza

New member
Joined
Sep 22, 2015
Messages
7
Reaction score
0
Points
0
Hello,
I need to populate the following table over three tabs using data (YTD 0815) pulled from our financial system (gl entries report)
I always populate the data manually however it is taking a lot of time as I always need to add new columns for each new client and do the same over the three tabs.
Can you recommend a formula which would help pull the data automatically?
Many thanks!
 

Attachments

  • gl entries report.xlsx
    16.4 KB · Views: 10
  • YTD 0815.xlsx
    39.2 KB · Views: 8
Back
Top