vba to cut and paste into newsheet through 3 condition on 3 column

**johnlara** · 04-19-2015, 03:35 AM

Dear Experts

I want the vba code to cut and paste from master to new sheet through 3 condition...

I usally download report from month day1 till next month day1 so i want make first condition select day of first in col c:c

IF Condition First In C:C Select Ist Data Of Every Month Select# = 1ST MARCH ( it might get chance for nextmonth report 1st april till 1stmay)
IF Condition Second In B:B After 12:00 Am Till 8:30 Morning Like(00:00 Till 08:30) Select# = 00:00 TILL 08:30
IF Condition Three In G:G Both B And D Select# = B AND D

pls find the attachment you may understand what am i looking for

**johnlara** · 04-19-2015, 01:41 PM

any experts help on this code?

Sub deletion()
Dim a, i As Long

a = Range("a1").CurrentRegion

With Application
.ScreenUpdating = False
For i = UBound(a) To 2 Step -1
If VBA.Day(a(i, 3)) = 1 And Format(a(i, 2), "hh:mm") >= "00:00" And Format(a(i, 2), "hh:mm") <= "08:30" Then
Rows(i).EntireRow.Delete
End If
Next
.ScreenUpdating = True
End With
End Sub

i want apply 3rd condition along with the code any one can help me?

vba to cut and paste into newsheet through 3 condition on 3 column

LinkBack

Thread Tools

Rate This Thread

Display

vba to cut and paste into newsheet through 3 condition on 3 column

Re: vba to cut and paste into newsheet through 3 condition on 3 column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Cut data from master and paste into next newsheet depends upon value of a col vba

[SOLVED] Range.Cut Paste on NewSheet

[SOLVED] copy and paste values to another sheet if value in one column matches condition

Copy Data between 2 dates and paste it newsheet

Condition Paste Formula in Column N based on Column A

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions