I am working on an interface. My sourcefile is an external database and I am importing the data, using ODBC, into Excel. The source file has one row per document number with the information: date, customer, currency, amount, bankname, jobinfo. To get the correct figures into General Ledger I need a link to another sheet, where the information has to go into columns. Per document number I need two rows in the columns, (one for the debit amount and one for the credit amount) for: document number, distribution account, distribution type, debit amount, credit amount, jobinfo, bankname. Account and type are based on jobinfo and bankname (lookup table), debit and credit amount is the same amount, but has to go in different rows
I made this links manually, but is it possible to copy them down automatically, based on the document numbers in the source file