Most valuable professional
  • Hot Topics

Excel Code To Look At Column C And If All Data Matches In Column AC Copy To Sheet 2

I have a file as laid out below. I need the code to look at column C and if the data matches then look at column AC. If all the data in column AC says 'NYA' then copy to sheet 2 like the second example. Thanks. Excel 2010 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Sheet1 As you can see below I have highlighted in yellow what needs to be copied as the data in C matches and in column AC they say NYA.

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of June 10, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel