HELLO EXPERTS,
I NEED TO WRITE A SIMPLE SQL TO EXTRACT DATA FROM A TABLE. TABLE IS ALREADY EXTRACTING DATA FROM MULTIPLE FILES AND IS REFRESHING WELL WHEN DATA IS UPDATED IN SOURCE FILES.
NOW FROM THIS TABLE I NEED TO WRITE COUPLE OF COMMANDS / SQL IN DIFFERENT SHEETS / WORKBOOKS WHICH MAY USE SOME KIND OF "REFRESH" OPTION WHEN NEEDED.
<tbody>
</tbody>
THIS IS THE HEADER AND FOR AN EXAMPLE I NEED TO TO MAKE A REPORT WHICH MAY BRING:
INVOICE NO.
BL DATE
P.I. NO.
BUYER
GROSS VALUE
DEPOSITS
NET VALUE
THAT MATCHES THE "BUYER" = "XYZ COMPANY" AND AUTOMATICALLY ADDING A TOTAL FOR:
GROSS VALUE
DEPOSITS
NET VALUE
NOW FROM ORIGINAL TABLE IF IT GET "REFRESHED" THE REPORT MAY ALSO HAVE AN OPTION TO "REFRESH" APPENDING NEW ENTRIES (IF ANY).
PLEASE GUIDE / ADVISE.
THANKS IN ADVANCE.
I NEED TO WRITE A SIMPLE SQL TO EXTRACT DATA FROM A TABLE. TABLE IS ALREADY EXTRACTING DATA FROM MULTIPLE FILES AND IS REFRESHING WELL WHEN DATA IS UPDATED IN SOURCE FILES.
NOW FROM THIS TABLE I NEED TO WRITE COUPLE OF COMMANDS / SQL IN DIFFERENT SHEETS / WORKBOOKS WHICH MAY USE SOME KIND OF "REFRESH" OPTION WHEN NEEDED.
Source.Name | INVOICE NO. | BL DATE | P.I. NO. | OFFICE | BUYER | CARTONS | QUANTITY | GROSS VALUE | DEPOSITS | NET VALUE | TENOR | DUE DATE | LC NO. | DESCRIPTION | SUPPLIER | SUPPLIER INV. NO. | IMPORT AMOUNT | VESSEL NAME | LOADING | DESTINATION |
<tbody>
</tbody>
THIS IS THE HEADER AND FOR AN EXAMPLE I NEED TO TO MAKE A REPORT WHICH MAY BRING:
INVOICE NO.
BL DATE
P.I. NO.
BUYER
GROSS VALUE
DEPOSITS
NET VALUE
THAT MATCHES THE "BUYER" = "XYZ COMPANY" AND AUTOMATICALLY ADDING A TOTAL FOR:
GROSS VALUE
DEPOSITS
NET VALUE
NOW FROM ORIGINAL TABLE IF IT GET "REFRESHED" THE REPORT MAY ALSO HAVE AN OPTION TO "REFRESH" APPENDING NEW ENTRIES (IF ANY).
PLEASE GUIDE / ADVISE.
THANKS IN ADVANCE.