branston
11-30-2019, 07:03 AM
Hi
Not having any joy with this so hoping someone can help.
I am trying to copy a select set of data and paste to to another tab (sheet2). The data on sheet1 consists of 4 columns. Column1 is a set of candidate pictures, columns 2,3,4 are the candidate scores. I would like to automate this process rather than using VLOOKUP or formulaes etc. as my llist of sheet1 can grow.
Sheet 2 is almost set up like a template with pre-marked areas for which the data needs to be pasted into. The scores are pasted underneath pictures.
(For now I have pre-marked the areas on sheet 2 but long term if the data on sheet 1 increases, I don't know if it's possible to create new areas /enlarge template on sheet 2 'on the fly' ?)
I have attached my worksheet and made some progress. I have also shown some examples of what the data would look like on sheet2. ('jpg1', 'jpg2' etc. are just text examples of the pictures themselves as I cannot upload pics.)
Also, I don't want the pictures once pasted to increase the size of the (middle) cells they are being pasted into. They pictures are 3x5 cells in size so will take up 3x5 cells.
Could anybody have a look and offer any help?
Not having any joy with this so hoping someone can help.
I am trying to copy a select set of data and paste to to another tab (sheet2). The data on sheet1 consists of 4 columns. Column1 is a set of candidate pictures, columns 2,3,4 are the candidate scores. I would like to automate this process rather than using VLOOKUP or formulaes etc. as my llist of sheet1 can grow.
Sheet 2 is almost set up like a template with pre-marked areas for which the data needs to be pasted into. The scores are pasted underneath pictures.
(For now I have pre-marked the areas on sheet 2 but long term if the data on sheet 1 increases, I don't know if it's possible to create new areas /enlarge template on sheet 2 'on the fly' ?)
I have attached my worksheet and made some progress. I have also shown some examples of what the data would look like on sheet2. ('jpg1', 'jpg2' etc. are just text examples of the pictures themselves as I cannot upload pics.)
Also, I don't want the pictures once pasted to increase the size of the (middle) cells they are being pasted into. They pictures are 3x5 cells in size so will take up 3x5 cells.
Could anybody have a look and offer any help?