Request support for a dynamic table, in the sheet1 will find some data that I extracted with a view created in SQL, Sheet2 will find yourself in a sample of how it should be the final report on the third sheet find the equivalence between the two tables , eg on sheet 1 there is the "mccnumdocmov" Sheet2 that corresponds to the field "Document", in the model Sheet4 I have a table as it should be dynamic, taking into account that the values in column "Credit" multiplication corresponds to the "mccvalotranloca" multiplied by the value "mccsignoclien" which can be +1 or -1, if the value of "mccsignoclien" is -1 means that the value is "Credit", if the sign of "mccsignoclien" is +1 means that e value is "Debit" and finally "Balance" is the diference between debits and credits; the "comments" field corresponds to "edvcomentario" of sheet1.
I forgot to mention that in the Sheet4 the Name, Telephone1, phone2, Fax, Country, City, Address and Department must be fetched automatically from sheet1 when i select the customer NIT in Sheet4.
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.