S
SBonner
Hello,
Each month I have to run a report (REPORT 2) and compare it with
another report (REPORT 1),
do some caluculations and generate a report with the combined data.
The accounts on each report are not necessarily the same, but they
all need to be on the final report, sorted by account.
I have seen some examples of how I might be able to do this,
but I don't know VBA well enough to make it work. Any help
would be greatly appreciated.
The Titles/Headings from REPORT 2 will be used.
The account descriptions which need to be matched start in cell A14.
REPORT 1 contains data for the first half of 2006(data will not
change).
REPORT 2 will be run each month end for the rest of this year.
If the acct desc is the same on both reports(matches):
Column F (Report1 Column F +Report2 ColumnF)
Column G (Report1 Column G +Report2 ColumnG)
If the acct desc is only in REPORT 1:
Columns B, C and D must be set to zero, and Columns E, F and G
values remain the same.
If the acct desc is only in REPORT 2:
Need the row of data, but no changes required to any values
Then I need to calculate totals for Columns B through G.
ColA ColB ColC ColD ColE ColF ColG
PTD PTD PTD YTD YTD YTD
Act Bud Var Act Bud Var
Total Costs
acct desc 2 PAmt 2 PBAmt2 PVAmt2 YAmt2 YBAmt2 YVAmt2
acct desc 3 PAmt 3 PBAmt3 PVAmt3 YAmt3 YBAmt3 YVAmt3
acct desc 4 PAmt 4 PBAmt4 PVAmt4 YAmt4 YBAmt4 YVAmt4
acct desc 5 PAmt 5 PBAmt5 PVAmt5 YAmt5 YBAmt5 YVAmt5
acct desc 14 PAmt 12 PBAmt12 PVAmt12 YAmt12 YBAmt12 YVAmt12
Total PTotal PBTotal PVTotal YTotal YBTotal YVTotal
Thanks
Each month I have to run a report (REPORT 2) and compare it with
another report (REPORT 1),
do some caluculations and generate a report with the combined data.
The accounts on each report are not necessarily the same, but they
all need to be on the final report, sorted by account.
I have seen some examples of how I might be able to do this,
but I don't know VBA well enough to make it work. Any help
would be greatly appreciated.
The Titles/Headings from REPORT 2 will be used.
The account descriptions which need to be matched start in cell A14.
REPORT 1 contains data for the first half of 2006(data will not
change).
REPORT 2 will be run each month end for the rest of this year.
If the acct desc is the same on both reports(matches):
Column E (Report1 Column E +Report2 ColumnE)
Column F (Report1 Column F +Report2 ColumnF)
Column G (Report1 Column G +Report2 ColumnG)
If the acct desc is only in REPORT 1:
Columns B, C and D must be set to zero, and Columns E, F and G
values remain the same.
If the acct desc is only in REPORT 2:
Need the row of data, but no changes required to any values
Then I need to calculate totals for Columns B through G.
ColA ColB ColC ColD ColE ColF ColG
PTD PTD PTD YTD YTD YTD
Act Bud Var Act Bud Var
Total Costs
acct desc 2 PAmt 2 PBAmt2 PVAmt2 YAmt2 YBAmt2 YVAmt2
acct desc 3 PAmt 3 PBAmt3 PVAmt3 YAmt3 YBAmt3 YVAmt3
acct desc 4 PAmt 4 PBAmt4 PVAmt4 YAmt4 YBAmt4 YVAmt4
acct desc 5 PAmt 5 PBAmt5 PVAmt5 YAmt5 YBAmt5 YVAmt5
acct desc 14 PAmt 12 PBAmt12 PVAmt12 YAmt12 YBAmt12 YVAmt12
Total PTotal PBTotal PVTotal YTotal YBTotal YVTotal
Thanks