We have all written programs to create comma delimited files
for import into Excel. Check this .csv out.
"Product","Qty","Dollar","Extend
Dollar"
"500-12","12","$100.00","$1200.00"
"389-HW","1","$50.00","$50.00"
"9088-9","2","$75.00","$150.00"
"19879-FIL","1","$20.00","$20.00"
"9876-98","1","$10.00","$10.00"
"75-P","3","$5.00","$15.00"
"","","=SUM(C2:C7)","=SUM(D2:D7)"
Quite ordinary wouldn't you say? But examine the last line.
Instead of adding the Dollar and Extend Dollar columns in the
program, insert the Excel formula to do the calculation in the
spreadsheet. Those with keen eyes will notice that the same thing
could be done for the Extend Dollar column.
Lee H. Burstein, President
Dynamic Systems, Inc.