Darryproduct
New Member
- Joined
- Jul 24, 2013
- Messages
- 8
There is a CTR-CAR (Customer Transaction report / Customer accrual report) excel file that has a "CTR" Tab and a "CAR" tab. The CTR tab has a "Rebate No" column and often we have to pull a list of 10 or more rebate ID sections from the CAR report into a blank excel sheet to provide sufficient support for the journal entries we are booking. This takes a lot of time sometimes. The lines in the CTR look like the below:
<tbody>
</tbody>
The sections of the CAR look like the below:
<tbody>
</tbody>Right above the Rebate description header there is a highlighted black line and 2 rows below the Rebate Total there is another black line.
Is there a macro that can pull the CARs from the "CAR" tab in an excel file with both the "CTR" & "CAR" tab into a separate blank worksheet where the black lines overlap and are next to each other lined up to down?
<tbody> </tbody> |
<tbody>
</tbody>
The sections of the CAR look like the below:
FUTURE SHOP - CO BU - 2017 - U - O&A APR ENDCAP PROTO 1.0 TABLET ACCESSORIES - $0.7K | ||||||||||
Rebate Number : 101002 | ||||||||||
Effective Dates : 02-APR-17 29-APR-17 | ||||||||||
Rebate Type FIXED AMOUNT GL Asset Account 12301 Accrued Co-op/MDF | ||||||||||
Sales Type GROSS SALES GL Expense Account 40303 Promotional Funding | ||||||||||
Rebate Tiers | ||||||||||
Customer Info 2172 | ||||||||||
Product Info .MCP...(I), .MCB...(I), .MMA...(I), .LSG...(I), .TAB...(I), .MSG...(I), .CBL...(I), .AVI...(I), .MPP...(I), .MPW...(I), .SRG...(I) | ||||||||||
Comments SF #86978 ; Prog51259. SF COMMENTS "Please deduct $700 from Rebate ID# 98616 for Belkin Endcap Fee for Proto 1.0 Tablet Accessories Hard Goods - APRIL LOG: 441985" | ||||||||||
Month | Rate % | Sales | Accrual | Adjust | Total Accrual | CM Ded | AP Ded | GL Ded | Total Ded | Balance |
May-17 | 0.00 | 0.00 | 0.00 | 700.00 | 700.00 | 0.00 | 0.00 | 0.00 | 0.00 | 700.00 |
Jul-17 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | (515.46) | 0.00 | 0.00 | (515.46) | 184.54 |
Dec-17 | 0.00 | 0.00 | 0.00 | (184.54) | (184.54) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Rebate Total | 0.00 | 0.00 | 515.46 | 515.46 | (515.46) | 0.00 | 0.00 | (515.46) | 0.00 | |
<tbody>
</tbody>
Is there a macro that can pull the CARs from the "CAR" tab in an excel file with both the "CTR" & "CAR" tab into a separate blank worksheet where the black lines overlap and are next to each other lined up to down?