I have a situation where I need to do the following:
Using the Start.xlsx file Starting on row 9, If F9 contains "x" then copy H9, I9, J9, & O9 to the workbook Desired Results sheet DATA1 to columns A,B,C, & K.
Using the Start.xlsx file Starting on row 9, If G9 contains "x" the copy J9, N9, H9, Q9 to the workbook Desired Results sheet DATA2 to
columns C,D, K, & Q.
I could have as many 100 rows to do this for. (I have attached the two spreadsheets and the desired results contains the data as if it were populated as I need it to be. Any help would be appreciated.
Thanks,
Met
Bookmarks