opportunity

I need an inexpensive, easy to learn Monte Carlo simulator. Any suggestions? Here's the scenario - Residents and nonresidents can apply for any of 100 opportunities in a particular state. Each opportunity has a limited number of spots. But, once 10% of the total slots are filled, nonresidents...

Hi, I have a program that creates a Data Base every time it is used, for me I think it was easy to do it, but now I do not know how to retrieva anyone of those reports created back to a form from which was sent (it can be a copy of the form in a different sheet), all I want is to have the...

Hey guys, I have two data sets that I want to combine. Data is currently on two different worksheets. Below is an example of what I am trying to do, but my actual data has more columns for both Opportunity and Contacts. I also have many more rows. <colgroup><col style="text-align...

Hi All. I'm hoping someone can help. I have a column of data that has duplicates. I do not want to remove duplicates as I still need the information in those rows for a sum count of the price, but I do need to identify 1 of each duplicate value in another column. So, I need the end result to...

Hi - Thank you in advance for help on this! I am trying to create a macro (or maybe multiple?) that looks at a a few fields in a "Raw Data" tab and exports results into a tab called "Opportunities". I have 4 categories listed in a column ("Lifestyle", "Multi", "Tech", "Auto" ). I am trying to...

I have the following sales data for 2016, 2017, and 2018: <tbody> Column A Column B <strike></strike> Column C Column D <strike></strike> Column E Column F <strike></strike> Column G Column H <strike></strike> Column I Column X Row 1 Opportunity Name Opportunity Close Date (US date)...

Hello Everyone, I am hoping someone may be able to help me out. I have a list of building addresses and unique building numbers generated from our system. I have another list of opportunities generated from the same system that contain two building numbers for each opportunity. Each...

Hi, I am very new to VBA and have been struggling to find everything I need in one place to complete a task I'd like to do. Any help would be much appreciated. I have a risk register which captures threats and issues that may occur within my projects. The outcome of those could be a task or an...

Hello All, I have been using some of the error handlers in my scripts. Well, i am an online learner and have learned most of these stuffs from videos where i did not get the opportunity to ask some questions. So i need help with the understanding of these error handlers. For example "on error...

Not sure if anyone can help on this but any ideas would be greatly appreciated. I have created a worksheet that is used as a price estimator and a click of a button sends it to the customer. What I would like it to (if possible) is that when I click the button to send it as an email, is to load...