I have a workbook template that loads MSN MoneyCentral Investor Currency Rates table using the Data connection link, into a worksheet each time that it loads.
On another worksheet a user inputs a currency rate that has been set by an administrator for the day.
If the rate entered is a certain percentage different to the MSN rate then this is flagged to the user with the use of formulas.
My problem is that MSN have changed their table recently, it no longer includes the euro which is one of the main requirements.
How may I resolve this so that the workbook continues to provide this currency resource?
please look this links, it may helpful to get a solution
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…