Create a simple Excel macro to ask the user which currency to convert AUD to (USD or EURO), then convert all AUD $ values in the current worksheet based on the correct currency conversion value in another worksheet (Both in the same workbook). Very simple calculation. Macro needs to first check that the cell format is a currency (eg. $, Euro, USD) and if it is and if the contents are numeric, multiply the cell value by the currency conversion value, and replace the cell value with the new currency and change the format to the correct currency format (Euro, USD). All rows need to be processed and all $ values need to be updated.
This is a quick, easy job, fast response is needed.
16 威客就此工作平均出价 $113
Nice to meet you, Rakumba I am experienced developer with 10 years experience I can help you quickly Relevant Skills and Experience Excel, VB Proposed Milestones $155 AUD - total