Hi all

This is probably really simple, however my knowledge of VBA is very basic & usually causes a lot of swearing on my part!

Each month I have to carry out a compliance check on my team (approx 60 employees) to ensure they are recording data accurately. When a defect is identified I have to take a screen grab. All information is input into excel.

What i am trying (and failing) to do is create a macro that will create a worksheet with the employees name (listed in column A), paste the screen grab from the clip board into the new worksheet then create a hyperlink to the new worksheet in the original.

eg employee 1's name is listed in cell a2. If he fails for any reason i want to be able to click an insert button (which will be in cell i2) which create a new worksheet copies the screen grab (that I have already got on the clipboard) then changes Cell i2 to a hyperlink to the new sheet.

Now i've managed to get it creating a sheet & naming it, but only for a specified cell (ie a2), so if employee 6 also fails it attempts to create a worksheet with employee 1s name again.

I'm sorry if this is easy & i'm just being dumb, but i'm pulling my hair out!

Thanks