Looking for Pair of Values in Same Column - VBA

Hi Akuini, that is what I'd like the code to do!

I wanted to ask, if you don't mind. If I wanted to do the opposite, and look for values 0 to 1 in Column H, instead of values of 1 to 0 like before. How would you write the code. The new G:H values would be added to Column D, instead of Column C.

Can this code be written with the code from before, so they can be run the same time. If it is difficult to write together, that'll be ok.

Capture15.PNG

Thank you Akuini! I appreciate any help you can give me.

Using your example above:
In Col B data ends at row 6, but in col C data ends at row 5.
If you import new data (then run the macro) where do you fill the data in col C, from row 6 or 7?

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.

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!