I need Excel VBA expert that can help m e

min $50 USD / hour

Completed

Posted

over 4 years ago

min $50 USD / hour

It is useful to rank foreign exchange currencies over time to identify market trends between these currencies. One way to help identify those trends is to create a table like the one shown below were a unique color has been placed in every cell for each currency code. This assignment is to create a macro that will perform this task. Duplicate the spreadsheet shown below and construct a macro to place a unique color for each of the eight different currency codes (JPY, AUD, CHF, NZE, EUR, USD, CAD, and GBP) for cells A2 through F9. The Excel spreadsheet is to be named Forex Strength. Two different independent control programs are to be written to accomplish this task. Main Program #1 will use nested FOR statements to select each cell one at a time and Main Program #2 will use nested DO loops. Both Main programs will select each cell one at a time and interrogate that cell to identify the currency code. That Main program will pass control and the currency code to a subroutine named Forexcolors. The Forexcolors subroutine will link a unique color code number to each foreign exchange and pass control that number back to the control program. The control program will then use that number to fill that cell with that unique color. Remember to dimension all variables and place a run button on the spreadsheet.

Excel

Visual Basic

Data Processing

Visual Basic for Apps

VB.NET

Project ID: 22675840

About the project

7 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@luiswilliam

Hi, e1128! I read the description of your project thoroughly. I understand your requirements initially and I have experiences of the field. I am a specialist of: * React.js, Angular and Vue.js for Front-end, * .NET Core API for Back-end side, And these are also my talented fields: - Web scrapping - Desktop Utility Development using C#, Java or C (Windows and other OS) - Wordpress blog, and other eCommerce website building such Shopify, Prestrashop and Squarespace For all of above, I can provide proofs of my past works. However, you can see my work reviews in profile page and confirm my work quality. Now, I have enough time to work for your project and I'm ready to go with you. Usually, I would provide a long term support about the work I delivered. Looking forward your contacting. Thanks! 1575424886161

$50 USD in 2 days

5.0

(8 reviews)

4.4

7 freelancers are bidding on average $51 USD/hour for this job

@zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$50 USD in 40 days

4.9

(139 reviews)

7.4

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.

$50 USD in 20 days

5.0

(120 reviews)

6.4

@Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs i am very interested in this project , i can write small vba code to colorize each currency as on the attached image will do it for 50$ only , can do it within 1 hour samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards

$50 USD in 1 day

4.9

(103 reviews)

5.5

@palinco2003

Good day, I am Paul, a professional web researcher and excel sheet data expert. I have read your order details. And really understand the data and information you want. I have helped other clients with similar tasks to get information on specific data on industry information, leads emails, marketing data, other indexes that will help your marketing and business needs. I am an excellent researcher. I don't just find the information I research to ensure what I get is useful factual and marketable information. I hold a master degree in management and very competent in what I do. I can adequately handle this task for you within your stipulated deadline. I am an expert in internet search and can get the most hidden and minute information from the web. See links to samples and previous similar tasks I completed for other clients. These are just a few of hundreds of other web research work I have successfully completed for my clients: https://www.freelancer.com/projects/data-entry/online-data-research-multiple-industry/?w=f https://www.freelancer.com/projects/research/managed-medicaid-market-research/?w=f https://www.freelancer.com/projects/research/internet-research-filter-needle-market/ https://www.freelancer.com/projects/data-entry/find-footwear-retailers-distributors/ https://www.freelancer.com/projects/internet-marketing/need-sports-betting-email-list-10946809/

$50 USD in 40 days