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
27 freelancere byder i gennemsnit £122 på dette job
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
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 !