I have inputs from my boss that will change that describes our forecasted future projects (year, state, total size, etc). I need to take his inputs and create the population of future projects. Right now it's manual.
I am trying to automate this, so that if the details of his inputs change i can automatically update the number of records in the population. I don't really know how to do this.
I think I need to create some rules (average project size in New Jersey = 2) therefore if total size in NJ = 20, number of project records in the population = 10.
Any ideas? Would this require VBA? I don't really know VBA
