If Dropdown box on sheet 1 says "Yes" then the clients name needs to appear on sheet 2

[shark323]

I've attached a spreadsheet I've put together to help explain what I'm trying to do.

It has 3 sheets - Main, SEV and then the sheet that I've put my Data Validation info in for my Dropdown boxes that say Yes, No or See Comments.

I want it that if someone says yes to Severance of Tenancy being required that the client's name is ported onto the SEV sheet but I don't want their name to port there if they don't required severance of tenancy - likewise I don't want a blank row being inserted into the SEV sheet because the formula returned the result "No" or "See Comments". On the SEV sheet I've shown what I want to appear in the client's name cell to hopefully make it obvious to you what I'm trying to achieve.

Any ideas? Your help would be very much appreciated!!

[newdoverman]

I think that this is what you want but am wondering why you have columns B and C the same on the SEV worksheet.

This is the formula in SEV!A2 to be ARRAY ENTERED and copied across and down.

Please Login or Register  to view this content.