There is that possibility is there that can help me with two tables
consist of the following fields:
Sheet 1:
This table is imported from a generated view in SQL, which is
aim is to generate a report with all related invoices,
payments and applied to each invoice notes and obviously the values
total outstanding of each invoice, which consist of the following
fields:
Sheet 2:
DESP DATE, DOCUMENT, VTO DATE, DATE
CURRENT DAYS, DETAIL, T. DOC, OFFICE, VAT, WB
NET, RETURN, DISCOUNT, PAYMENTS, BALANCE
The aim is the following, make a macro in which it can
select the number of the ID or identification number of the person and the system I
bring all documents (invoices, debit notes, credit notes, receipts).
I send the file to look at that I'm talking and I
indicate what would be the best option.
I've already been doing a filtering MSQUERY but as need is
generate a report as you can see on page 2, I have wanted to
automate with a macro that selecting the cedula of
person, I bring all documents and make it
corresponding operations.
what I really want is that you can select on page 2 customer NIT (cell H13) and the system I fill in the fields for operations for each invoice sheet 2 (debit notes to add, subtract and credit notescash receipts)
On page 3 to find the relationship of the cells between the two sheets.
On the third sheet is a table with the relationship between the tables of each sheet, the idea is that the sheet 2 in cell H13, you can select the customer NIT (extracted from the sheet 1) and the system will fill the fields I on page 2 with data from sheet 1 to perform the operations for each invoice (bring invoices, debit notes to add, subtract credit notes and cash receipts).
Note: on page 2 is the format that you want to generate
Thanks for your help
consist of the following fields:
Sheet 1:
This table is imported from a generated view in SQL, which is
aim is to generate a report with all related invoices,
payments and applied to each invoice notes and obviously the values
total outstanding of each invoice, which consist of the following
fields:
Sheet 2:
DESP DATE, DOCUMENT, VTO DATE, DATE
CURRENT DAYS, DETAIL, T. DOC, OFFICE, VAT, WB
NET, RETURN, DISCOUNT, PAYMENTS, BALANCE
The aim is the following, make a macro in which it can
select the number of the ID or identification number of the person and the system I
bring all documents (invoices, debit notes, credit notes, receipts).
I send the file to look at that I'm talking and I
indicate what would be the best option.
I've already been doing a filtering MSQUERY but as need is
generate a report as you can see on page 2, I have wanted to
automate with a macro that selecting the cedula of
person, I bring all documents and make it
corresponding operations.
what I really want is that you can select on page 2 customer NIT (cell H13) and the system I fill in the fields for operations for each invoice sheet 2 (debit notes to add, subtract and credit notescash receipts)
On page 3 to find the relationship of the cells between the two sheets.
On the third sheet is a table with the relationship between the tables of each sheet, the idea is that the sheet 2 in cell H13, you can select the customer NIT (extracted from the sheet 1) and the system will fill the fields I on page 2 with data from sheet 1 to perform the operations for each invoice (bring invoices, debit notes to add, subtract credit notes and cash receipts).
Note: on page 2 is the format that you want to generate
Thanks for your help
erfect, thanks a lot