-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
copy to sheet
-
D
VBA - If unique value (ID) found in list, copy row to sheet2, if duplicate ID found, then paste first instance (based on date) to sheet 2, etc..
Hi VBA masters. I need some help with some more complex if then statements and movement of data amongst tabs based on those if then statements. Thank you in advance!! The short: I seek to take a source file and split it up based on two scenarios. 1. If an Employee ID shows up once in Column...- DK643
- Thread
- copy to sheet rsu split duplicates vba & excel
- Replies: 7
- Forum: Excel Questions
-
J
Copy rows to different sheets based on multiple criteria excel VBA macro
Sub CopyToSheets() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case ws.Cells(rownum, 8)...- Jyotirmaya
- Thread
- copy and filter copy if copy to sheet excel vba excel vba macro if and
- Replies: 9
- Forum: Excel Questions
