Looking for Pair of Values in Same Column - VBA

Hi Akuini,

Thanks for your help. Is there a way you can keep adding to the last available row in Column C. If I import new values to Column H, and run the code, the values in Column C are all replaced. I'd like to keep adding values to Column C. I've provided a picture below as an example. Thanks!Capture12.PNG

When I import new values to column G:H, I delete all the old values and import the new ones. Theoretically, after running the code, new values from Column G will be copied to the next available row in Column C. Your code from before worked exactly how I want it to, but it doesn't let me import new G:H values and add to Column C, it replaces the values instead.

Thank you for all your help Akuini! I hope you can help me with this.