Færdiggjort

Excel VBA Simple Logical Funtions Seperated By GOTO Line Numbers

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

Færdigheder: Databehandling, Excel, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: excel vba goto label in another sub, excel vba label, vba goto end, vba line label, access vba goto, goto statement in vbscript, excel vba goto label, if then goto vba, email excel range vba simple, excel vba simple form entry, vba simple project excel, need excel vba simple box inventory list, excel vba simple projects, excel bank reconciliation vba simple, simple excel vba project

Om arbejdsgiveren:
( 0 bedømmelser ) Dudley, United Kingdom

Projekt-ID: #16097175

Tildelt til:

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-stor Mere

£210 GBP in 3 dage
(548 bedømmelser)
8.1

27 freelancers are bidding on average £122 for this job

Webxpert4u

Hello, I am ready to fix excel using VBA. Can you send me excel file ? Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writ Mere

£210 GBP in 5 dage
(156 bedømmelser)
7.2
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 dage
(250 bedømmelser)
7.3
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 e Mere

£180 GBP in 3 dage
(231 bedømmelser)
7.3
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 usi Mere

£180 GBP in 5 dage
(209 bedømmelser)
7.2
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 dage
(226 bedømmelser)
6.9
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 dage
(187 bedømmelser)
6.7
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 Mere

£70 GBP på 1 dag
(143 bedømmelser)
6.0
shanki161

>>>>>Genuine and Reliable<<<<<< Let us do this for you. We are up for a DEMO to show our expertise on this [url removed, login to view] will follow all the instructions and always available for 24*7 support on skype(voice+text+video). Mere

£277 GBP in 5 dage
(30 bedømmelser)
5.3
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 dage
(8 bedømmelser)
5.5
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 Applicat Mere

£116 GBP in 4 dage
(55 bedømmelser)
5.5
ExtraNet

VBA expert here, with both an academic and professional background in IT. I've gone through your entire description and it's pretty straight-forward. There are a couple of minor details as to the approach you'd prefer Mere

£30 GBP på 1 dag
(12 bedømmelser)
4.1
yh2013

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

£88 GBP in 3 dage
(14 bedømmelser)
4.3
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 Ri Mere

£166 GBP in 2 dage
(8 bedømmelser)
3.9
£138 GBP in 3 dage
(14 bedømmelser)
3.6
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 h Mere

£80 GBP in 3 dage
(8 bedømmelser)
3.2
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 dage
(4 bedømmelser)
2.8
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 ( Mere

£210 GBP in 5 dage
(2 bedømmelser)
2.8
haleem0786

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

£150 GBP in 3 dage
(5 bedømmelser)
2.4
£66 GBP in 3 dage
(1 bedømmelse)
2.4
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 complete Mere

£40 GBP in 3 dage
(3 bedømmelser)
1.5