japan

  1. D

    Multiple DB Query in same workbook.

    Hi All, I have 3 Oracle DB's (India, China, Japan) I have written a macro which connects to DB & extracts records. But I have to run each macro 3 times by changing the DB name. Is there any way where macro automatically connects to 3 DB's and extract India records to Sheet1, China records to...
  2. L

    Excel links corrupt

    Hi, I linked a file in Excel 10 to a file sent to me from Japan. The links all seemed to be fine. I saved and closed both files. I then reopened my file and the links were fine, but when I opened the Japan file at the same time, my links instantly turned to #REF !. I tried to redo it several...
  3. G

    Multiple Table download from the internet to Excel Yahoo Finance Japan

    Dear All, I hope you can help me I am trying to download historical share data for share 8088 from yahoo Japan. The first page of the table I need is in the following location: - https://info.finance.yahoo.co.jp/history/?code=8088.T&sy=1983&sm=11&sd=19&ey=2017&em=12&ed=19&tm=d&p=1 I then...
  4. J

    Question on Grouping

    I have a data set with region, Country and Cities. I want to have them in Groups in a Pivot table. <colgroup><col><col><col span="2"><col><col><col></colgroup><tbody> Region Country Location Daily Sales Weekly Sales Month To Date Year to Date Asia China Hong Kong 100 500 4000 40000 Macau...
  5. G

    Showing sub items for only certain items in a Power BI table

    Hi all, I have data for countries and I want to group the European ones and to show a subtotal. So my table rows would be something like. Europe UK France Germany Italy US Japan China I easily created a Europe group through right clicking in the field list. However, when I put...

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