Hello
I need help with creating and printing sales commission voucher form with in excel. All my sales data on the excel sheet below.
Is it possible to click on a total commission on each row, then commission voucher page open up to view and print. Once the voucher printed, i want a auto check on cell that voucher has been viewed or printed.
Here is the example of my spreadsheet. I would all the fields to be pre-filled on commission vouchers.
[TABLE="width: 1717"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Contract Date[/TD]
[TD]Buyer 1 First Name[/TD]
[TD]Buyer Last Name[/TD]
[TD]Year Model[/TD]
[TD]Make[/TD]
[TD]Model[/TD]
[TD]Deal Type ID[/TD]
[TD]Sales Price[/TD]
[TD]Sale Price[/TD]
[TD]Commision Gross Profit[/TD]
[TD]Lender Name[/TD]
[TD]Sales Person Name[/TD]
[TD]Commission[/TD]
[TD]Bonus[/TD]
[TD]Total Commission[/TD]
[/TR]
[TR]
[TD]12/30/2014[/TD]
[TD]SERGEY[/TD]
[TD]LEVAKIN[/TD]
[TD="align: right"]2012[/TD]
[TD]Dodge[/TD]
[TD]Ram 5500[/TD]
[TD]C[/TD]
[TD]39500[/TD]
[TD] [/TD]
[TD="align: right"]872.65[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 300.00[/TD]
[TD] [/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]12/23/2014[/TD]
[TD]JOSE[/TD]
[TD]ISLAS[/TD]
[TD="align: right"]2007[/TD]
[TD]Chevrolet[/TD]
[TD]Silverado 2500HD[/TD]
[TD]F[/TD]
[TD]28599.99[/TD]
[TD]Full[/TD]
[TD="align: right"]5307.93[/TD]
[TD]ALLY BANK[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]1/3/2015[/TD]
[TD]RANDY[/TD]
[TD]WILLIAMS[/TD]
[TD="align: right"]2010[/TD]
[TD]Chevrolet[/TD]
[TD]Silverado 2500HD[/TD]
[TD]C[/TD]
[TD]17000[/TD]
[TD] [/TD]
[TD="align: right"]-212.05[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 200.00[/TD]
[TD] [/TD]
[TD] $ 200.00[/TD]
[/TR]
[TR]
[TD]1/5/2015[/TD]
[TD]DARWIN[/TD]
[TD]MCKINLEY[/TD]
[TD="align: right"]2012[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]27988[/TD]
[TD]Full[/TD]
[TD="align: right"]-380.15[/TD]
[TD]ALLY BANK[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 200.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]1/3/2015[/TD]
[TD]THOMAS[/TD]
[TD]DO[/TD]
[TD="align: right"]2014[/TD]
[TD]Jeep[/TD]
[TD]Cherokee[/TD]
[TD]C[/TD]
[TD]24904.7[/TD]
[TD] [/TD]
[TD="align: right"]351.69[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Greg Dalton[/TD]
[TD] $ 200.00[/TD]
[TD] [/TD]
[TD] $ 200.00[/TD]
[/TR]
[TR]
[TD]12/26/2014[/TD]
[TD]OMAR[/TD]
[TD]MALDONADO[/TD]
[TD="align: right"]2010[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]25988[/TD]
[TD]Full[/TD]
[TD="align: right"]2907.71[/TD]
[TD]CPS, INC.[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]12/23/2014[/TD]
[TD]Peter[/TD]
[TD]Franz[/TD]
[TD="align: right"]2008[/TD]
[TD]Ford[/TD]
[TD]Expedition[/TD]
[TD]F[/TD]
[TD]16750[/TD]
[TD] [/TD]
[TD="align: right"]-674.47[/TD]
[TD]PENTAGON FEDERAL CREDIT UNION[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 200.00[/TD]
[TD] [/TD]
[TD] $ 200.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]Jerrod[/TD]
[TD]Simmons[/TD]
[TD="align: right"]2012[/TD]
[TD]GMC[/TD]
[TD]Yukon Hybrid[/TD]
[TD]F[/TD]
[TD]40988[/TD]
[TD]Full[/TD]
[TD="align: right"]-1484.85[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 200.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]DAVID[/TD]
[TD]SCOTT[/TD]
[TD="align: right"]2011[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]26988[/TD]
[TD]Full[/TD]
[TD="align: right"]1060.26[/TD]
[TD]FORT WORTH CITY CREDIT UNION[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 300.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 400.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]JAY[/TD]
[TD]MASSEY[/TD]
[TD="align: right"]2012[/TD]
[TD]Jeep[/TD]
[TD]Wrangler[/TD]
[TD]F[/TD]
[TD]29988[/TD]
[TD]Full[/TD]
[TD="align: right"]2819.51[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]RYAN[/TD]
[TD]ROBERTSON[/TD]
[TD="align: right"]2007[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]14888[/TD]
[TD]Full[/TD]
[TD="align: right"]1047.24[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 300.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 400.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]GEORGE[/TD]
[TD]WARREN[/TD]
[TD="align: right"]2012[/TD]
[TD]RAM[/TD]
[TD]1500[/TD]
[TD]F[/TD]
[TD]27988[/TD]
[TD]Full[/TD]
[TD="align: right"]3634[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]1/6/2015[/TD]
[TD]Lee[/TD]
[TD]Dunayer[/TD]
[TD="align: right"]2011[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]C[/TD]
[TD]28600[/TD]
[TD] [/TD]
[TD="align: right"]1794.44[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 300.00[/TD]
[TD] [/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]1/6/2015[/TD]
[TD]JOHN[/TD]
[TD]GIVEN[/TD]
[TD="align: right"]2012[/TD]
[TD]Jeep[/TD]
[TD]Wrangler[/TD]
[TD]C[/TD]
[TD]33988[/TD]
[TD]Full[/TD]
[TD="align: right"]3630.22[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00
[/TD]
[/TR]
</tbody>[/TABLE]
I need help with creating and printing sales commission voucher form with in excel. All my sales data on the excel sheet below.
Is it possible to click on a total commission on each row, then commission voucher page open up to view and print. Once the voucher printed, i want a auto check on cell that voucher has been viewed or printed.
Here is the example of my spreadsheet. I would all the fields to be pre-filled on commission vouchers.
[TABLE="width: 1717"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Contract Date[/TD]
[TD]Buyer 1 First Name[/TD]
[TD]Buyer Last Name[/TD]
[TD]Year Model[/TD]
[TD]Make[/TD]
[TD]Model[/TD]
[TD]Deal Type ID[/TD]
[TD]Sales Price[/TD]
[TD]Sale Price[/TD]
[TD]Commision Gross Profit[/TD]
[TD]Lender Name[/TD]
[TD]Sales Person Name[/TD]
[TD]Commission[/TD]
[TD]Bonus[/TD]
[TD]Total Commission[/TD]
[/TR]
[TR]
[TD]12/30/2014[/TD]
[TD]SERGEY[/TD]
[TD]LEVAKIN[/TD]
[TD="align: right"]2012[/TD]
[TD]Dodge[/TD]
[TD]Ram 5500[/TD]
[TD]C[/TD]
[TD]39500[/TD]
[TD] [/TD]
[TD="align: right"]872.65[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 300.00[/TD]
[TD] [/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]12/23/2014[/TD]
[TD]JOSE[/TD]
[TD]ISLAS[/TD]
[TD="align: right"]2007[/TD]
[TD]Chevrolet[/TD]
[TD]Silverado 2500HD[/TD]
[TD]F[/TD]
[TD]28599.99[/TD]
[TD]Full[/TD]
[TD="align: right"]5307.93[/TD]
[TD]ALLY BANK[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]1/3/2015[/TD]
[TD]RANDY[/TD]
[TD]WILLIAMS[/TD]
[TD="align: right"]2010[/TD]
[TD]Chevrolet[/TD]
[TD]Silverado 2500HD[/TD]
[TD]C[/TD]
[TD]17000[/TD]
[TD] [/TD]
[TD="align: right"]-212.05[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 200.00[/TD]
[TD] [/TD]
[TD] $ 200.00[/TD]
[/TR]
[TR]
[TD]1/5/2015[/TD]
[TD]DARWIN[/TD]
[TD]MCKINLEY[/TD]
[TD="align: right"]2012[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]27988[/TD]
[TD]Full[/TD]
[TD="align: right"]-380.15[/TD]
[TD]ALLY BANK[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 200.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]1/3/2015[/TD]
[TD]THOMAS[/TD]
[TD]DO[/TD]
[TD="align: right"]2014[/TD]
[TD]Jeep[/TD]
[TD]Cherokee[/TD]
[TD]C[/TD]
[TD]24904.7[/TD]
[TD] [/TD]
[TD="align: right"]351.69[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Greg Dalton[/TD]
[TD] $ 200.00[/TD]
[TD] [/TD]
[TD] $ 200.00[/TD]
[/TR]
[TR]
[TD]12/26/2014[/TD]
[TD]OMAR[/TD]
[TD]MALDONADO[/TD]
[TD="align: right"]2010[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]25988[/TD]
[TD]Full[/TD]
[TD="align: right"]2907.71[/TD]
[TD]CPS, INC.[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]12/23/2014[/TD]
[TD]Peter[/TD]
[TD]Franz[/TD]
[TD="align: right"]2008[/TD]
[TD]Ford[/TD]
[TD]Expedition[/TD]
[TD]F[/TD]
[TD]16750[/TD]
[TD] [/TD]
[TD="align: right"]-674.47[/TD]
[TD]PENTAGON FEDERAL CREDIT UNION[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 200.00[/TD]
[TD] [/TD]
[TD] $ 200.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]Jerrod[/TD]
[TD]Simmons[/TD]
[TD="align: right"]2012[/TD]
[TD]GMC[/TD]
[TD]Yukon Hybrid[/TD]
[TD]F[/TD]
[TD]40988[/TD]
[TD]Full[/TD]
[TD="align: right"]-1484.85[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 200.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]DAVID[/TD]
[TD]SCOTT[/TD]
[TD="align: right"]2011[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]26988[/TD]
[TD]Full[/TD]
[TD="align: right"]1060.26[/TD]
[TD]FORT WORTH CITY CREDIT UNION[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 300.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 400.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]JAY[/TD]
[TD]MASSEY[/TD]
[TD="align: right"]2012[/TD]
[TD]Jeep[/TD]
[TD]Wrangler[/TD]
[TD]F[/TD]
[TD]29988[/TD]
[TD]Full[/TD]
[TD="align: right"]2819.51[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]RYAN[/TD]
[TD]ROBERTSON[/TD]
[TD="align: right"]2007[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]F[/TD]
[TD]14888[/TD]
[TD]Full[/TD]
[TD="align: right"]1047.24[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Paul Ryan[/TD]
[TD] $ 300.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 400.00[/TD]
[/TR]
[TR]
[TD]12/22/2014[/TD]
[TD]GEORGE[/TD]
[TD]WARREN[/TD]
[TD="align: right"]2012[/TD]
[TD]RAM[/TD]
[TD]1500[/TD]
[TD]F[/TD]
[TD]27988[/TD]
[TD]Full[/TD]
[TD="align: right"]3634[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00[/TD]
[/TR]
[TR]
[TD]1/6/2015[/TD]
[TD]Lee[/TD]
[TD]Dunayer[/TD]
[TD="align: right"]2011[/TD]
[TD]Ford[/TD]
[TD]F-150[/TD]
[TD]C[/TD]
[TD]28600[/TD]
[TD] [/TD]
[TD="align: right"]1794.44[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wayne Streeter[/TD]
[TD] $ 300.00[/TD]
[TD] [/TD]
[TD] $ 300.00[/TD]
[/TR]
[TR]
[TD]1/6/2015[/TD]
[TD]JOHN[/TD]
[TD]GIVEN[/TD]
[TD="align: right"]2012[/TD]
[TD]Jeep[/TD]
[TD]Wrangler[/TD]
[TD]C[/TD]
[TD]33988[/TD]
[TD]Full[/TD]
[TD="align: right"]3630.22[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD]Wade Bragg[/TD]
[TD] $ 400.00[/TD]
[TD] $ 100.00[/TD]
[TD] $ 500.00
Code:
[/TR]
</tbody>[/TABLE]
