VBA code that will enter data into the next empty row from imported text file

[C_merr]

Every week I refresh a text CSV file into sheet 1 that has a different commodity for each row and many columns worth of data. I Then take some of the data from sheet 1 and copy it into the next available row (1 row per week) in sheet 2. Using a formula will not work because every time I refresh the Text file if I have the cells linked, the previous weeks will change to the most current data too. I am looking for a way to Take data from sheet 1 when it updates each week and place it into the next empty row in sheet 2 automatically. Is this possible?

 

[thraling]

on which criteria you choose the row to copy on Sheet2?

 

[C_merr]

I will choose the row if it matches the commodity. for example, my sheet 2 is "wheat" and have multiple sheets for each different commodity. But i only use Columns H-O of data for the corresponding commodity.

 

[C_merr]

I got it figured out! thank you though!