Add worksheets named on multiple cell values

[TheImmortal]

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

[JimmyA]

Hello TheImmortal

Welcome to the Forum.

Are you able to post the code you have so far? (just remember to put code tags round it when posting, Highlight code and press the "Wrap Code Button" (the hash symbol)). If you can I will try and make so changes to it to work for all employees.

Without seeing what you have it is difficult to say but you could probably do something like an input box to enter the employee you want to set the sheet up for..

Cheers

Jim