Search for number in Column A, then upload image in next column if number does not exist.

Hey all,

Context:
I am working on a userform ticketing system for our team to log their software issues. Each new issue entered receives a ticket number. These issues are logged on Sheet 1. I would like users to have the option to add screenshots to Sheet 2 next to their ticket number.

I am looking for the code to take the uploaded pictures and paste them into Sheet 2.
Here's the upload part:

Please Login or Register  to view this content.

I would like it to look like this:
Sheet 2: Column A is the ticket number. Column B is the image. Continue adding pictures to the next empty column if user continues to upload from the userform.

Sheet 2 Example.JPG

TL;DR
Search Column A in Sheet 2 for a generated number from Sheet 1's userform. If the number is not in Column A, add the generated number to Column A and uploaded picture to Column B, then Column C, etc. depending on number of pictures uploaded.

Thoughts?

Plenty of thoughts. Also easy to implement.
But, lazy to start a workbook from scratch - can you share what you have so far?

Hey Jasper,

'Hate to bug you -- Any ideas on how to implement this solution?