Excel VBA Simple Logical Funtions Seperated By GOTO Line Numbers

£20-250 GBP

Completed

Posted

over 6 years ago

£20-250 GBP

Paid on delivery

Im using VBA in Excel to work on a fairly simple flow chart that i have created. I have 5 Variations of the flow chart that i would like to eventually test as part of my larger project. The data set im using is simply a range of numbers from Cell A2:A13. The numbers are to two decimal places. Because i have 5 flow chart variations of testing this number range i decided to Code one and then because it works logically in sequence i can re-arrange the various sections and complete the rest easier. Its just using general Logic Functions. If the result is TRUE i would like to then GOTO another section if FALSE another section or possibly just to display "FALSE" Here are the Six Logical Function Tests i would require you to complete 1) Does the range (A2:A13) contain any duplicate numbers - if yes display FALSE in Cell D9, if no GOTO next Logical Test 2) Are 4 or more of the numbers in the range between 1.00 and 1.99 & are there 0 numbers between 2.00-2.99 - if yes display FALSE in Cell D9, if no GOTO one of the other Logical Tests below 3) Are there any numbers in the range between 1.50-2.00 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test 4) Are there any numbers in the range between 2.50-2.80 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test 5) Are there specifically 3 to 5 numbers in the range between 1.00-1.99 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test 6) Are 6 or more numbers in the range between 1.00-1.99 - if yes GOTO a specified Logical Test, if no GOTO a different specified Logical Test Basically once i have the logic funtions coded for each stage i can piece all my Flow Chart Variations togther using a GOTO command, if that makes sense? If you could clearly show the Logical Funtions above seperated and with a GOTO Line Number at the start of each one i can use this to work with my drawn flow charts. Does this make sense? If you require more information im happy to talk you through some more of what i require. Regards, Andrew

Data Processing

Excel

Software Architecture

Visual Basic

Visual Basic for Apps

Project ID: 16097175

About the project

25 proposals

Remote project

Active 6 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:

@jaylancer43

Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay

£210 GBP in 3 days

5.0

(752 reviews)

8.5

25 freelancers are bidding on average £126 GBP for this job

@schoudhary1553

Greeting, I have understood your Excel VBA Simple Logical Funtions Seperated By GOTO Line Numbers task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps

£180 GBP in 3 days

4.9

(359 reviews)

8.0

@P0L

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£100 GBP in 3 days

4.9

(337 reviews)

7.3

@deepbluetech

Hi Andrew, I have studied the flowchart you have described. I can implement the logic using Excel VBA and deliver within 3 days. Cheers, Arul

£180 GBP in 3 days

5.0

(259 reviews)

7.4

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

£100 GBP in 2 days

4.9

(242 reviews)

7.0

@cugamelover

I'm an Excel expert. I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/

£180 GBP in 5 days

4.8

(219 reviews)

7.2

@periyannas

Hi, Nice to know your requirement. I am an excel vba expert, and have delivered 4 vba projects in the past 20 days. Would like to do the job mentioned. It will take three to four hours for me to complete the task you have mentioned. However deadline is 24 hours. I will deliver as soon as I complete it. Looking forward to working with you. Thank you. Regards.

£80 GBP in 3 days

5.0

(114 reviews)

6.4

@langlangFan

I am VBA, Excel expert, Already have good experience in my profile. I can help you what you need from VBA, Excel. Feel free to contact me. Good Luck !

£150 GBP in 3 days

4.9

(14 reviews)

6.0

@rengrish

Hi I have 10+ years of experience in Excel & VBA. I can complete this job right now on the spot. Could you please attach the spreadsheet ? Please check my past reviews. I can complete the job within hour or tw. Thank You Regards Rishi

£70 GBP in 1 day

4.9

(158 reviews)

6.0

@abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC -- JS,Google extensions and google scripts I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

£116 GBP in 4 days

4.9

(69 reviews)

5.6

@yh2013

I worked many projects for Excel that include macros (VBA). Check my portfolio. I have the required expertise.

£88 GBP in 3 days

4.8

(16 reviews)

4.3

@haleem0786

i have good command over Ms excel especially pivot table, charts, advance formulas, VBA, Macro etc. Thanks

£150 GBP in 3 days

4.9

(24 reviews)

4.0

@chintuag

Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ribbon Buttons, Interaction with external applications for data exchange (Outlook, PDF, Access), etc. Regards Chintu

£166 GBP in 2 days

5.0

(10 reviews)

4.0

@anisheco

Hi, I have 8+ years of experience in report/process automation using MS Excel with VBA. I read the job description and was able to track through the logical steps you mentioned. I believe, we can create an interactive interface to take input from users to incorporate the conditions in Macro. I would like offer my expertise on this project, and request you to consider my proposal. I am new to this platform, and looking forward to build a reputation by providing great solutions.

£83 GBP in 1 day

5.0

(3 reviews)

3.3

@Denishpatel96

Need to know more details for exact bid price for this project. Hope to hear from you soon. Thank you.

£23 GBP in 2 days

5.0

(4 reviews)

3.4

@Carlosemadrizmor

FREE SUPPORT AND UPDATE AFTER RELEASE I am Software Engineer; +10 years in: - Model relational database (Oracle, MYSQL, Postgress, MsAccess) / Syntax SQL - Software developer (ASP, PHP, Visual Bacic) - Excel a (Macros, VBA, Functions, Pivot tables) I adjust to their needs, totally tolerant to any change that may arise during development. I can work full-time for you. I am ready to WOR any day, any time of the day.

£210 GBP in 5 days

5.0

(5 reviews)

3.6

@dhivya1enigma

I have sound knowledge in Excel Macro. I would be completing the job in time. Bidding minimum to win. I have read your requirement kindly share the excel sheet with data so that I can understand the logic flow completely.

£40 GBP in 3 days

5.0

(3 reviews)

1.4

@nishantsahni09

Dear Andrew, My name is Nishant and I am just starting in freelancer. I have worked as a data analyst and I find this project as a good opportunity to start working as a freelancer. I have hands on experience with many vba coding projects in my past work. Hope you find my profile interesting. I will be waiting for your response. Kind regards, Nishant

£90 GBP in 3 days

0.0

(0 reviews)

0.0

@bmeenehan

Hi there Andrew, This is a pretty simple project, which I can definitely bash out in a couple of hours I've worked extensively with Excel VBA, mostly in the Financial sector, creating calculators, graphs and printer friendly pages. I wouldn't recommend using GOTOs, at they can quite easily break if you need to make further changes. Rather, build a Switch Statement to check values, then a new sub for each possible answer. It's a little more leg work in the beginning, but makes your code more robust, and easier to modify and expand at a later stage. An event listener (or multiple listeners) will let your code run automatically whenever you change a value. Or just make a button, then assign the macro you want to run. Please feel free to give me a shout if you want some help with this. If not I hope I've sent you in the right direction!

£66 GBP in 2 days

5.0

(1 review)

0.0

@jkava

Hello, I have a great experience in VBA for Excel. Your description has many details and everything is clear for now. It would be great if you could provide me an example sheet to be more accurate. I work mainly over Upwork service so I don't have many ratings on Freelancer. Please tell me the deadline for this job. If you have any questions, please do ask. Best wishes Ivan

£55 GBP in 3 days