IF cell contains "yes" then provide a series of rows containing data or a column

[seekingshred]

Hello

New forum member here and a novice/ intermediate at Excel. Could use some help as I'm not able to get through this on my own.

So presumably I got a data validation list in the first column with Yes/No. When the user chooses the option yes I want the actions and costs column to appear. I'm stuck with the multiple data I got to show its nothing like a Lookup or like that and I can't seem to find a way how to do it

Yes / No	Actions	Costs
	Legal	Legal
	Costs	Costs
	info bulletin	information bulletin
	Market Value	Market Value
	Business income	Business income
	fine paid	fines paid
	Garage	Garage
	Unused area	Unused area

<tbody>
</tbody>

 

[My Aswer Is This]

So you have a Data Validation list In all you cells in column A
And if you choose "Yes" You want columns B and C Visible
But if you choose "No" you want Columns B and C Hidden

Is that what you want.
And you know this will require Vba

 

[My Aswer Is This]

If the answer to my questions are yes then try this:
If No please re explain your needs.

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

With this script it will run any time you manually enter or from a Data Validation list choose Yes or No

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  2/11/2019  6:06:19 PM  EST
If Target.Column = 1 Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
If Target.Value = "Yes" Then Columns("B:C").Hidden = False
If Target.Value = "No" Then Columns("B:C").Hidden = True
End If
End Sub