Writing sql for a table to extract information for reporting

shah0101

Board Regular
Joined
Jul 4, 2019
Messages
118
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.

Source.NameINVOICE NO.BL DATEP.I. NO.OFFICEBUYERCARTONSQUANTITYGROSS VALUEDEPOSITSNET VALUETENORDUE DATELC NO.DESCRIPTIONSUPPLIERSUPPLIER INV. NO.IMPORT AMOUNTVESSEL NAMELOADINGDESTINATION

<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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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.

source.nameinvoice no.bl datep.i. No.officebuyercartonsquantitygross valuedepositsnet valuetenordue datelc no.descriptionsuppliersupplier inv. No.import amountvessel nameloadingdestination

<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.









can a vba code help me on that?


Any one?
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,114,002
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top