Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows from Sheet1 to Sheet2 when Column B values equal "X" andColumn C values 100
How do I copy rows (Columns A,B,D only, values only) from Sheet1 to
Sheet2, same workbook. when Column B values equal "X" and Column C values 100. Help appreciated J.P. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows from Sheet1 to Sheet2 when Column B values equal "X"and Column C values 100
On Jun 21, 5:38*pm, u473 wrote:
How do I copy rows (Columns A,B,D only, values only) from Sheet1 to Sheet2, same workbook. *when Column B values equal "X" and Column C values 100. Help appreciated J.P. Sub SAS_CopyValuesIF() Dim r As Double Dim i As Long r = 16 'start row on destination sheet For i = 1 To Cells(Rows.Count, "b").End(xlUp).Row If UCase(Cells(i, 2)) = "X" And Cells(i, 3) 100 Then Sheets("sheet4").Cells(r, 1).Value = Cells(i, 1).Value Sheets("sheet4").Cells(r, 2).Value = Cells(i, 2).Value Sheets("sheet4").Cells(r, 3).Value = Cells(i, 4).Value r = r + 1 End If Next i End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows from Sheet1 to Sheet2 when Column B values equal "X"and Column C values 100
Thank you,
Well appreciated, J.P. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Rows Multiple times "changing" values in one column | Excel Programming | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
Cut rows if contains "Done" from sheet1, and paste onto next available row in sheet2 in the same workbook. | Excel Programming | |||
Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
Copy values only, sheet1 to sheet2 without Selection | Excel Programming |