Hello All,
I have created a data cube which is created on batch every morning. Ideally this will need ot be a DB, but in the mean time I need to query this data set and drop it into a template of other reports.
I have created a query in MS Query, which I reference in VBA to extract to a...
I have a problem in Excel to which i seeking a solution.
I have imported some External data using the Query option and I am able to Refresh it as and when I want.
In another location in the file, I have given reference to a particular cell that I am importing (eg. on Cell A3 I am saying =G121...
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.