Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer entire row to another sheet
i want to apply following condition
IN SHEET1 if A2="ABC" Transfer all data in row 2 to row 2 in sheet 2 pls help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer entire row to another sheet
try
sub transferif() if range("a2")="ABC" then rows(2).cut sheets("sheet2").range("a2") end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "aditya" wrote in message ... i want to apply following condition IN SHEET1 if A2="ABC" Transfer all data in row 2 to row 2 in sheet 2 pls help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
transfer entire row to another sheet
Hi,
try Sub copyrange() ' With Sheets("Sheet1") If Range("A2") = "ABC" Then Rows(2).Copy End If End With With Sheets("Sheet2").Range("A2") .PasteSpecial xlPasteValues .PasteSpecial xlPasteFormats Application.CutCopyMode = False End With ' End Sub "aditya" wrote: i want to apply following condition IN SHEET1 if A2="ABC" Transfer all data in row 2 to row 2 in sheet 2 pls help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
How can I transfer a required data from sheet 1 to sheet 2 automat | Excel Discussion (Misc queries) | |||
how to transfer data from sheet to sheet with new range? | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) |