Hello everyone;
I've undertaken a task beyond my VBA abilities, and I'm hoping to get some assistance! Hopefully I'll be able to dissect the solution code to learn from it so it won't happen again.
Here are the basic requirements raised to me:
We have 2 worksheets. One retains the raw data, the other contains a grid. (Assessment and Graph)
On the assessment worksheet, there are categories of information, with many potential items underneath, each containing a description field, impact, and likelihood score.
Impact and Likelihood are scored on a 1-5 scale.
On the Graph sheet, there is a Impact/Likelihood table, with those same 1-5 values.
The goal is to populate the Items from the assessment worksheet into the Graph worksheet.
For items that contain the same Impact and Likelihood, subsequent entries within that value will be on the next line of text.
For the purposes of the example spreadsheet provided, I have pre-populated the values in the graph worksheet.
I have no array names defined currently, go nuts if it's necessary!
Actual size of the assessment data will be 100+ Lines, thus looking for the way to automate it.
Thank you in advance for any assistance on this. I'm really anxious to see what I can learn from the code provided.
Bookmarks