Thursday, April 19, 2012

yogi_Duplicate Data Rows For Double Entry Accounting

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #511    Apr 19, 2012     www.energyefficientbuild.com.

user adam_sirum said:
yogi_Duplicate Data Rows For Double Entry Accounting

Hi,
My company tracks employee reimbursements on google spreadsheets with each line equal to one reimbursement.  However inorder to import these reimbursements into quickbooks (double entry accounting), each reimbursement needs to be converted into 2 lines.  I don't want to use a non-array formula as there are thousands of entries and I need it to by dynamic.  Please see my example spreadsheets.  I will be forever grateful.
Thanks in advance!
Adam

---------------------------------------------------------------------
following is a solution to the problem ... I haveshown the original data rows in sheet yogi_Sheet1 and I have duplicated the rows in sheet yogi_Sheet1-Duplicate Entries