Excel Query with IF, Vlookup and Data Validation

[ANAND KUMAR]

Dear Experts,

I found myself in a situation of help - I have a file which is attached at following URL

https://drive.google.com/open?id=0Bxtc6jUuxe_pY0hoQXBsaWNhOTg

So If C24 is Yes then E25 needs a value (from drop down – otherwise it needs an error message to detail the spec). Equally if C24 is No or blank then E25 must also be blank (or show error message)

Same is also true for C22 and E22

How can I lock it too? I also need to add a button at the bottom to export to pdf.

Thanks in Advance for any Help.

 

[ANAND KUMAR]

Yes. Went to desktop copied the path of file by Shift+Right click and made changes accordingly. But unfortunately didn't work.

Don't know why as I am novice with Excel.

Would it be helpful if you could share the file via mail into my Inbox.

 

[L. Howard]

I am quite weak in the area of PDF, just did look it up to see what it was about. I know very little about it and have never used any PDF's.

A new post asking for help with PDF's would be a better way to go.

Howard

 

[ANAND KUMAR]

I have a code which can export, But unable to assign this with Macro / Button.

Sub luxation2()
Dim Filename As String
Filename = "ANANDKUMAR"



Dim shtAry()
ReDim shtAry(1) ' this is an array of length 2
For i = 1 To 2
shtAry(i - 1) = Sheets(i).Name
Debug.Print Sheets(i).Name
Next i
Sheets(shtAry).Select
Debug.Print ThisWorkbook.Path & ""


ActiveSheet.ExportAsFixedForma<wbr>t xlTypePDF, ThisWorkbook.Path & "/" & Filename & ".pdf", , , False

End Sub

Could you please have a look over this.

 

[L. Howard]

With the button on the sheet, right click the button and select Assign Macro then find the macro name in the pop up window click on it then OK.

Howard

 

[ANAND KUMAR]

I have appended these two codes together and luckily problem got resolved.

Thanks a lot Howard for your continuous support ☺.