Looking for Pair of Values in Same Column - VBA

Originally Posted by awsexcel123

Hi Akuini. If new data is imported and the macro is run, the new data will fill in the next available row in Column C (In the case in the example, this will be Row 7). All new data, when macro is run, will imported to the next available cell in each column.

Thanks Akina! You've been great. I appreciate your patience.

But next available cell in col C is row 6 not 7 ???

Originally Posted by Akuini

But next available cell in col C is row 6 not 7 ???

Hi Akuini. Youre right. Last available or empty row in Column C would be Row 6. Thanks!