Insert data to last row of a range- VBA

dim the selected range as an array & write a for loop to find an empty row.

if you post your workbook, I will write you the code.

thank you for the help, here is my workbook file with sensitive data removed.

Thank you, I have posted a workbook sample!

Is this a possible start?

Please Login or Register  to view this content.

Thank you! I'm pretty unfamiliar with coding VBA but every bit of information helps!

Give this a whirl...

Please Login or Register  to view this content.

if I helped you, please give me some flair

Thank you so much! Exactly what I was looking for, I appreciate it very much!

Originally Posted by vhoffman

Thank you so much! Exactly what I was looking for, I appreciate it very much!

Awesome, glad it worked! If you run into any problems, I'll help you out :D

Here I mistakenly thought that you would select a range as you mentioned in your first post.
If you want hard code the values. (unlikely)

Please Login or Register  to view this content.

If your values are below each other (here in G1 to G3)

Please Login or Register  to view this content.

If your values are beside each other (here G1 to I1)

Please Login or Register  to view this content.