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"
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
@@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 .
@@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)
This is super nice!!!
Thank you!!
Thanks bro...
Great sir you genious
Thanks Sandeep!
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"
thank for your comment.
you can take help from following tutorial :
th-cam.com/video/VmtEM5-RkQY/w-d-xo.html
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
Thank you.
But how to use else if , if in multiple ledger transforming to their concern destination worksheet.
for any specific vba code, you can write to exceldestination@gmail.com
@@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 .
@@ExcelDestination what happened about the coding of my email file . plz break the silence
@@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)
And make the condition from cell row 5 until row 30 colom 3 and colom 4
Thanks ... Thanks.
Nice
thanks
How about 5 condition? Please give me solution
Thank....👍👍👍👍👍