Simpler way to browse multiple files

[dntel123]

Hey people,

Need some help with browsing for files, take a look at the picture attached otherwise be super hard to explain.

That done, you can see that I have 2 attachments, 1 & 2 and you can see there path on the computer.

Next to these on the right 2 buttons, attachment 1 & 2 gain, when clicked they browse for any file on the computer and then place its path as text in the correct cell. Its in turn on another sheet used to attach those files to email messages.

So attachment 1 & 2 buttons work for C2 and D2 but thats because they are specificly coded like that, and as you can see from the image I have 30 rows so thats 60 buttons, as u can guess I don't want to code each one individually.

So what Im looking for is a way to say assign those buttons to a cell, so when you browse it refers to that cell and places the path in it, without having to code 60 buttons.

Sorry if I'm not explaining it very well but hopefully you get my jist.

Any help is really appreciated anyway! Thanks!

Liam