Search Rows For Indicator, Return Certain Values

[SanFelippo]

Hi,

The Data I have covers 100 Rows and 266 Columns. The first 133 columns are going to simply contain either an “N” or a “Y” indicator. Ineed a Macro that I can attach to a button that when pressed, will go through the rows and search for the “N” indicators. If it finds an “N” indicator, I need it to do the following:

1. Grab the Column Header Name of the Column that is 133 Columns to the right of the Column it found the “N” indicator in and paste it onto a tab called “Error Tabulation” in cell B2.
2. Grab the value of the cell whose coordinates will be Cell (The current row being searched, Column EH) and paste it into cell D2.

There is more I need this Macro to do, but I figure I should start simple and then expand upon it once the base coding is done.


Any help is appreciated.

Thanks

 

[SanFelippo]

Amazing, everything works perfectly. Can't thank you enough.

 

[JoeMo]

Amazing, everything works perfectly. Can't thank you enough.

You are welcome - thanks for the update.

 

[Rahulwork]

Hey...

Pls help me in below thread. It's urgent


https://www.mrexcel.com/forum/excel-questions/1073520-help-userform.html