VBA if else statement with multiple conditions - Excel VBA

[@gullivergimeno7586]

This is super nice!!!

[@ExcelDestination]

Thank you!!

[@alshdesignstudio5552]

Thanks bro...

[@sandeepkumar-cx4or]

Great sir you genious

[@ExcelDestination]

Thanks Sandeep!

[@Sarfoo93]

How to use these conditions on time? For example if work done within certain time it should "Met" and if not done within time line it should show "Not met"

[@ExcelDestination]

thank for your comment.
you can take help from following tutorial :
th-cam.com/video/VmtEM5-RkQY/w-d-xo.html

[@anilkumardaharwal904]

if in a case the value of A1= A2=A3=A4= till A ActiveSheet.UsedRange then add the G1+G2 upto G ActiveSheet.UsedRange can be possible write a VBA code to check this condition . Request for answer on my mail ID pls

[@1gopalakrishnarao]

Thank you.

[@nilimasenapati6660]

But how to use else if , if in multiple ledger transforming to their concern destination worksheet.

[@ExcelDestination]

for any specific vba code, you can write to [e-mail]

[@nilimasenapati6660]

@@ExcelDestination ok I will submit my file with the problems in details and for a possible solutions; to this id tomorrow and I am hopeful that the same will be resolved by you. Thank u for replying thank u so much. I am really glad .

[@nilimasenapati6660]

@@ExcelDestination what happened about the coding of my email file . plz break the silence

[@nilimasenapati6660]

@@ExcelDestination Coding for extracting data from data base between any two different dates
While run Show Compile error wrong number of arguments or invalid property assignment
My Date is under column 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61
plz correct the code
Private Sub CommandButton1_Click()
Dim i As Long
Dim x As Integer
Sheet5.Range("A" & 2, "M" & 50000).ClearContents
For i = 3 To Sheet1.Range("B100000").End(xlUp).Row
If Sheet1.Cells(i, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) >= CDate(Me.TextBox1) And _
Sheet1.Cells(i, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61)

[@foxycikgu1410]

And make the condition from cell row 5 until row 30 colom 3 and colom 4

[@MohAboAbdo]

Thanks ... Thanks.

[@javedahmed8343]

Nice

[@ExcelDestination]

thanks

[@foxycikgu1410]

How about 5 condition? Please give me solution
Thank....👍👍👍👍👍