I'm working on creating financial reports (Income Statement, Balance Sheet, etc.) through PowerPivot. I've got all the data set up the way I need it and ran a small test sample to verify it would work. It did, but I was using the JetReports add-in to refresh my G/L Accounts to make sure that none were missed. Essentially, it would read every Account No. from my table and create a row for that No., copying the other columns on that row to each subsequent row. This way, I could write one formula that would read that Account No and find the corresponding data from PowerPivot.
My problem is that I can't use Jet Reports with the 64-bit Excel and I have too much data for 32-bit to handle. I figured I could write a macro that would replicate the Jet Reports functionality by reading each value in my Account No table in PowerPivot and creating a row... However, I can't figure out how to access the data from VBA. Can anybody help me out, please?
My problem is that I can't use Jet Reports with the 64-bit Excel and I have too much data for 32-bit to handle. I figured I could write a macro that would replicate the Jet Reports functionality by reading each value in my Account No table in PowerPivot and creating a row... However, I can't figure out how to access the data from VBA. Can anybody help me out, please?