Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel QuickBooks workBook
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking QuickBooks Pro reports to Excel | Excel Discussion (Misc queries) | |||
QuickBooks export to Excel | New Users to Excel | |||
Excel template to Quickbooks Pro | Excel Discussion (Misc queries) | |||
Excel and Quickbooks | Excel Discussion (Misc queries) | |||
Excel QuickBooks workBook | Excel Programming |