Adjusting Range Contents Based on contents of Three other columns

**VTHokie11** · 03-22-2012, 09:56 AM

I currently have a macro that makes a tagcloud / wordcloud off of a selected range of single column qualitative cells.

What I want to add to this is the ability to adjust that selected range based on the contents of three other columns (these columns only have a "Yes" or a "-" in them). If there is a "Yes" for "Days away from work" it should go from appearing once in the original range to appearing three times in the new adjusted range. If there is a "Yes" for "Restriction or Transfer" it should go from appearing once in the original range to twice for the new adjusted range. Lastly if it has a "Yes" for "Other" it should continue to only appear once.

In effect by adjusting this range based on these three other columns the final tag will have different size texts for specific injury descriptions than if it would have ran off the originally selected range of information.

The following is a picture of the sheet i'm working with I can provide anyone with the workbook as well. Thanks for any help / advice on this! I'll continue to plug away at it from here as well.

ColumReference.JPG

Edit: Its important to not that the user may select any numbers of cells starting and ending at any point within any of the columns (although they will more than likely only run it on columns with qualitative descriptive data, as tag clouds of numbers don't really serve much purpose). Reference to the three columns will have to use their title's rather than column location as the column location is more likely to change than the title of those columns.

**StephenR** · 03-22-2012, 09:59 AM

Yes, please post a workbook illustrating what you are trying to do.

**VTHokie11** · 03-22-2012, 01:55 PM

This forum rocks I love that you can actually attach workbooks. I've attached the workbook the macro uses a couple of other files that must be stored in the local directory in order for the tag cloud to be generated. However I don't think providing those files is necessary.

Currently the user selects a single columned range of qualitative information (example: highlights 15 cells in the "Type Description" column). From there simply running the macro takes this input and creates a tagcloud based on the frequency of each description.

What I want to add to this is the option for the user to create a tag cloud that also takes into account what i'm calling "severity". Severity is represented by the three columns highlighted in yellow, with days away from work being the most severe, transfer second most severe, and other the least severe.

What I need to figure out how to code is something that references these three columns (preferably through their header name rather than column location), and adjusts the input based on these columns. So if a Type Description of say "Drunk Driving" had it's "Yes" corresponding to "Days Away from Work" it would appear three times rather than once in the new adjusted range. The code would do this for each cell within the original selected range and then feed this new range of "CloudData" to the macro.

Ideally I'd like for the macro to display both the tag cloud created off the original range and the tag cloud which takes into account severity side by side on two different web browser controls. But for now I just want to figure out how to create this adjusted input and give the user the choice to run it off one method or the other (as I foresee displaying each simultaneously being rather difficult).

Please let me know if I did not make something clear, and thank you!