I am creating a cross training matrix for my work. It looks at a persons name and job skill level to paste an image representing there competency level into a cell.
I have a script that works great. It looks at a cell value and then pastes an image into another cell on another sheet.
My question is, is there a better way?
Right now the code is pretty long and it is just working with one row (name) and only a handful of jobs. The completed table will have up to 250 names and maybe 35 individual jobs. It takes three lines of code just to populate one cell, so coding this whole thing will be huge. and I am worried it will lag.
I have thought about breaking it up into chunks but even doing that will take huge amount of coding.
Is there a loop or something else that will make this a lot simpler?
Bookmarks