I have absolutely no VB experience. Just yesterday I taught myself some basics enough to code a series of prompt boxes following a model in an Excel textbook. I'm at work and I need some help.
I built a work book that takes inputs, calculates and then produces an output. The output has 3 catergories each of which is an IF conditional with 4 options (exceeding, meeting, below, alert.) The focus of the output is a 4th catergory which is an aggregate of the prior 3 and it is also in the same 4 option scheme. The aggregate is a rating given to the firm to which the workbook is dedicated to.
What I am looking to do is build a VB macro command button to take the firm name and put it in another worksheet in a specified location based upon the aggregate rating it has been given. Every time the original VB macro runs at its conclusion it will put the firms name in the appropriate spot as to create a clear set of firms that fall within each category of exceeding, meeting, below, or alert. The addition of subsequent firm names should be added directly below the one in its category that came before it.
I really tried my best to explain this in the simplest way possible. I admit that having no tangible knowledge of the problem and desired solution the description will come off as very abstract. Once again, I have no programming experience what so ever (I am a Marketing major) so I can't really provide you with any starter code that I'm working on. Thanks very much to all those who attempt to help.