I need to "message" a report from QB. Here is the layout
Each Group Title Starts at Col F with a description say "TTTTTT", the
rest of the row is blank
Each transaction for THAT title starts at the NEXT row columns H:T
Last row for this group end with "Total TTTTTT" in column Fn and a sum
for column T at column T
The next group is repeated after a blank row.
What I need is to create a new sheet that copies each group (H:T)n WITH
"TTTTTT" repeated with each transaction and make sure that the sum is
the same. Let me have a go in simulating it in ASCII !!!!
T1T1T1T1T1
H2......T2
H3......T3
Total T1T1T1T1T1 sum(T2:T3) in T4
What I need
T1T1T1T1T1 H2......T2
T1T1T1T1T1 H3......T3 and verify that sum(T2:T3)
is correct by summing it in VBA and comparing it with the last row in
the group.
I have several groups following that, and same structure.
Any Guidance will be greatfully apprecaited
Bookmarks