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

Hi
could you post some example data rows (plain text - no attachment
please) and your expected result based on this example data

--
Regards
Frank Kabel
Frankfurt, Germany

"Toni" schrieb im Newsbeitrag
...
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?