Create Trouble Report

[CHC Consulting LLC]

Sheet 1 = Main Data
Sheet 2 = Trouble Sheet

In A2 of "Trouble Sheet", if cell AB3 of "Main Data" equals yes than C3 of "Main Data".

In A3 of "Trouble Sheet", Return the number in column C of the next record that is "YES" in column "AB".

I also want to bring over other fields and was planning on using VLookup for that?

Any Suggestions?

 

[Michael M]

first question, answer In A2 of Trouble sheet

=IF(Main Data!AB3="Yes",Main Data!C3,"")

 

[CHC Consulting LLC]

first question, answer In A2 of Trouble sheet

=IF(Main Data!AB3="Yes",Main Data!C3,"")

Thanks... any idea on the second one? That is the part I am really struggling with.

 

[Michael M]

I might not be understanding the other parts correctly, but I think you will only do them with VBA.
What triggers the next record in Column "C" ?
AND
What other fields.
A small sample of data and what you want to achieve would be helpful.
Have a look at the 2nd line of my tag to download a copy of HTML Maker for Excel, which will let you post sample data.