Most valuable professional
  • Hot Topics

Excel Clear contents based on contents in another sheet

Hello everyone. New VBA user here and in need of some help. I have a workbook with two sheets, “Max Data” and “Min Data”. Both sheets have the same number of columns with data in columns A and B being the same. Columns C and on have unique values. Part Number 1 2 3 4 5 Part Number 1 2 3 4 5 I have a macro that will clear contents on the “Max Data” sheet based on certain criteria. The result will look something like this: Part Number 1 2 3 4 5 Part Number 1 2 3 4 5

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

This thread is current as of June 24, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel